Thanks a lot, simple and clear explanation. One thing as a consequence - final percentage not "linked" with other attributes, in my case my "sales" are of two types and if I try to see % change for each of them, BI only shows total of both. Anyway thanks a lot!
Please help.. I have created date calendar for hospitality dashboard in which friday and Saturday are consider as weekend. So in, weekstartdate, wat should I mention as first day of week. Should I mention it as Sunday as 1?
What about if you have two other coulmns i need to filter by per week, so each week has about 500 rows of data? Im doing what you have done but i just get the same sales this week value repeating
Hi I have downloaded your file. When I pulled City into the rows and weeknum into Columns, your WOW change% do not reflect by city. Is that a way to do it? thank you!
Hi Sir, Your videos is gr8 👍 only one question. During creating measures just after = i cannot get table name with date like your 'sales Order [Date] , i am doing some silly 😜 mistake or my power bi version is old. Could you please assist
Why dont you use single function to get weekly sales? calculate(sum(sales), filter(date_table, date_table[weeknumber]=earlier(date_table[weeknumber])))
Thanks... exactly what I intended to do... however, I am getting an error in RANKX, 'A single value for Column 'WeekStartDate' in Table cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such min, max, count, or sum to get a single result'... Can you advise please
Great explanation! I have one question: Will the week number be effected when comes to leap year? For some years have 52 weeks, some other years have 53 weeks. Thank you!
Thanks for the tutorial! How can i compare the same week last year? Eg week 4 in 2022 vs 2021. And how to compare the first week of the year against last week on last year. Eg week 1 in 2022 vs week 53 in 2021. Million thanks!
Please watch this video.. Compare Amount of this Year/Month vs Last Year in PowerBI | PowerBI Tutorial | SamePeriodLastYear th-cam.com/video/Mx6-1icI_8Y/w-d-xo.html
One of the issue I found with this. e.g. if the start date of week is between 26th Dec 2022 - 1st Jan 2023, the week number could be both Week 53 of 2022 and Week 1 of 2023, then wow goes wrong.
Hi thank you for the video, very helpful content. I am struggling with getting the "Sales This Week" & "Sales Last Week" measures to formulate correctly. Am I messing up the formula for these somehow? Sales This Week = CALCULATE(SUM(OrderDetail_All[MarginDollars]), FILTER(ALL(OrderDetail_All),OrderDetail_All[WeekRank]=MAX(OrderDetail_All[WeekRank]))) Sales Last Week = CALCULATE(SUM(OrderDetail_All[MarginDollars]), FILTER(ALL(OrderDetail_All),OrderDetail_All[WeekRank]=MAX(OrderDetail_All[WeekRank])-1))
@@MITutorials When I am trying to compare my actual count of "sales" vs the calculated measure for "Sales This Week" it is calculating a number that I do not understand.
Hello Sir, firstly amazing tutorial, really good stuff. I am hoping you can help. I want to implement the same thing but instead of sum function i want do count function based on either a job finish date column or status column, is this possible?
we didn't take year here.
what if the year changes.
How one can show the 1st week of new calendar year to the last week of previous year?
Thanks a lot, simple and clear explanation. One thing as a consequence - final percentage not "linked" with other attributes, in my case my "sales" are of two types and if I try to see % change for each of them, BI only shows total of both. Anyway thanks a lot!
Hi, it works but if I want to filter by country, it’s not working. And if I want to add year, how should I do?
How can I perform the same steps as I've a separate date table from the main table?
Hello,
Thank You for the tutorial, Is there a way to show sales for the week based on the filter selection (different locations).
I want to add wow% in column field, can we add in column formula instead of measure
Please help.. I have created date calendar for hospitality dashboard in which friday and Saturday are consider as weekend. So in, weekstartdate, wat should I mention as first day of week. Should I mention it as Sunday as 1?
What about if you have two other coulmns i need to filter by per week, so each week has about 500 rows of data? Im doing what you have done but i just get the same sales this week value repeating
thanks a lot for the video! however for 'this week sale' and 'last week sale', I got all identical volumes by each weekrank, how could that happen?
Hi I have downloaded your file. When I pulled City into the rows and weeknum into Columns, your WOW change% do not reflect by city. Is that a way to do it? thank you!
Hi, how to compare random week ? ex: week 11 and week 17.
I made a Tutorial for you please check this out.
th-cam.com/video/QPVSxxoN5sg/w-d-xo.html
This is good tutorial but what if I add product in the same I am still getting week on week for all products same what should I do ?
Hello,
Is it possible to create a line chart inside 100% Stacked Column Chart Visual? If yes, request if you can please explain the process.
Regards
Dropping the tutorial tomorrow morning @ 10 am..
@@MITutorials thank you very much...looking forward to it
How to get weeks without creating a new column?
Thanks for the video, it works but fails when slicers are applied. Can you help me explain that please 🙏
Hi this is very easy to understand and helpful! thanks for making this video.
Glad it was helpful!
Hi Sir, Your videos is gr8 👍 only one question.
During creating measures just after = i cannot get table name with date like your 'sales Order [Date] , i am doing some silly 😜 mistake or my power bi version is old. Could you please assist
I used same formula but for prev week only getting sum not week wise figures
Same thing here, any solution yet?
Why dont you use single function to get weekly sales?
calculate(sum(sales),
filter(date_table,
date_table[weeknumber]=earlier(date_table[weeknumber])))
I am getting same values for all the weeks in sales this week measure
Thanks... exactly what I intended to do... however, I am getting an error in RANKX, 'A single value for Column 'WeekStartDate' in Table cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such min, max, count, or sum to get a single result'... Can you advise please
It’s basically saying you have multiple values in the column which u are trying to rank.
Dense?
Thanks for the help and good work!
Thanks It works but filter not working on this calculated SUM
Great explanation! I have one question: Will the week number be effected when comes to leap year? For some years have 52 weeks, some other years have 53 weeks. Thank you!
This will work with the leap year as well.
Thanks for the tutorial! How can i compare the same week last year? Eg week 4 in 2022 vs 2021. And how to compare the first week of the year against last week on last year. Eg week 1 in 2022 vs week 53 in 2021. Million thanks!
Please watch this video..
Compare Amount of this Year/Month vs Last Year in PowerBI | PowerBI Tutorial | SamePeriodLastYear
th-cam.com/video/Mx6-1icI_8Y/w-d-xo.html
One of the issue I found with this. e.g. if the start date of week is between 26th Dec 2022 - 1st Jan 2023, the week number could be both Week 53 of 2022 and Week 1 of 2023, then wow goes wrong.
Instead of Infinity..can we name it something instead?
You can use IF statement and define your desired output.
@@MITutorials thanks
Hi thank you for the video, very helpful content.
I am struggling with getting the "Sales This Week" & "Sales Last Week" measures to formulate correctly. Am I messing up the formula for these somehow?
Sales This Week = CALCULATE(SUM(OrderDetail_All[MarginDollars]), FILTER(ALL(OrderDetail_All),OrderDetail_All[WeekRank]=MAX(OrderDetail_All[WeekRank])))
Sales Last Week = CALCULATE(SUM(OrderDetail_All[MarginDollars]), FILTER(ALL(OrderDetail_All),OrderDetail_All[WeekRank]=MAX(OrderDetail_All[WeekRank])-1))
The Measure looks correct.. What's the issue you are facing ?
@@MITutorials When I am trying to compare my actual count of "sales" vs the calculated measure for "Sales This Week" it is calculating a number that I do not understand.
Very nice video. Can you make a video on HR data
You can apply same logic to any data set..
hai sir make a video on digital marketing advertisiments report creation..
Hello Sir,
firstly amazing tutorial, really good stuff.
I am hoping you can help.
I want to implement the same thing but instead of sum function i want do count function based on either a job finish date column or status column, is this possible?
this is amazing! thank you
Great explanation...
thanks 👍
Bad way to do it
I am getting same values for all the weeks in sales this week measure