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

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

[MGleb-tpkr]

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

[Happinuii]

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

[jatinshridhar]

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?

[shoaibrehman]

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

[mengyizhou]

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?

[joannewong]

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?

[jaitiwari]

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?

[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

[vishnukrishnan]

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

[marmarmarmar]

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!

[kat]

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!

[kelechiogbogu]

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

[sandeshkhilari]

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

[Jayantyd]

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

[lalitkaushik]

If we don't have sales values only have completed and not completed remark how to calculate that in week

[achintkaur]

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 ?

[laikahmed]

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

[PhongNguyen-vqyo]

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

[warrentso]

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!