Forum Discussion
Week Over Week Percent Change in a table or Matrix table by Supplier or Department
Super UserAnonymous , Can you highlight what is wrong. The formula can be run on week rank
Have these new columns in Date Table, Week Rank is Important in Date/Week Table
Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX('Date','Date'[Year Week],,ASC,Dense) //YYYYWW format
These measures can help
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Hi Amitchandak,
Thank you so much for the quick response! 🙂 I would like to show the percent change from the previous week for a specific groupling - for example the screen shot below in excel is showing Facebook current week amount total for 91-180 days is $4M and the % change from the previous week is -4%. How would I show this exact example in a table or matrix in PowerBi. I was able to show this is in a graph, but only by selecting on a departmentr filter for each one rather than have the totals and percenategs all in one table.