Calculate Week Over Week change % in PowerBI | Mi Tutorials | Previous Week Sales

[@MGleb-tp1kr]

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!

[@kingelpat]

Hello, Thank You for the tutorial, Is there a way to show sales for the week based on the filter selection (different locations).

[@jatinshridhar5083]

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?

[@Ya_boi_Al]

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

[@vishnukrishnan3263]

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

[@MITutorials]

Dropping the tutorial tomorrow morning @ 10 am..

[@vishnukrishnan3263]

@@MITutorials thank you very much...looking forward to it

[@jaitiwari241]

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?

[@joannewong1971]

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?

[@mengyizhou1400]

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?

[@Happinuii]

Hi this is very easy to understand and helpful! thanks for making this video.

[@MITutorials]

Glad it was helpful!

[@kat1643]

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!

[@kelechiogbogu6617]

Thanks for the video, it works but fails when slicers are applied. Can you help me explain that please 🙏

[@sandeshkhilari1990]

I want to add wow% in column field, can we add in column formula instead of measure

[@PhongNguyen-vq5yo]

Hi, how to compare random week ? ex: week 11 and week 17.

[@MITutorials]

I made a Tutorial for you please check this out. kzbin.info/www/bejne/h4G5hKuupLNoqck

[@laikahmed7120]

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

[@MITutorials]

It’s basically saying you have multiple values in the column which u are trying to rank.

[@shoaibrehman9988]

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

[@Jayantyd]

How can I perform the same steps as I've a separate date table from the main table?

[@carterallington6398]

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]

The Measure looks correct.. What's the issue you are facing ?

[@carterallington6398]

@@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.

[@SIRU_Thalikulam]

Why dont you use single function to get weekly sales? calculate(sum(sales), filter(date_table, date_table[weeknumber]=earlier(date_table[weeknumber])))

[@achintkaur401]

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 ?

[@marmarmarmar7522]

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!

[@MITutorials]

This will work with the leap year as well.

[@amangarg8052]

I used same formula but for prev week only getting sum not week wise figures

[@Adefactory]

Same thing here, any solution yet?

[@farhankhairandi9976]

Thanks for the help and good work!

[@warrentso2548]

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!

[@MITutorials]

Please watch this video.. Compare Amount of this Year/Month vs Last Year in PowerBI | PowerBI Tutorial | SamePeriodLastYear kzbin.info/www/bejne/g6mZXmSfmK6Sbrs

[@NewChannel-u4r]

How to get weeks without creating a new column?

[@gauthamk4173]

I am getting same values for all the weeks in sales this week measure

[@isaddam7]

Thanks It works but filter not working on this calculated SUM

[@ajaymanral7843]

Very nice video. Can you make a video on HR data

[@MITutorials]

You can apply same logic to any data set..

[@ChromeBookmarks]

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.

[@sabkuchdhela191]

Instead of Infinity..can we name it something instead?

[@MITutorials]

You can use IF statement and define your desired output.

[@sabkuchdhela191]

@@MITutorials thanks

[@johndalevacaro5687]

this is amazing! thank you

[@gametrailerz6117]

Dense?

[@LiveLoveMazy]

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?

[@fealgu100]

Great explanation...

[@manojdesharajpally9868]

hai sir make a video on digital marketing advertisiments report creation..

[@sandeshkhilari1990]

thanks 👍

[@siddharthakar7190]

Bad way to do it

[@aditijoshi7784]

I am getting same values for all the weeks in sales this week measure