Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Week Over Week Percent Change in a table or Matrix table by Supplier or Department

Hey all, Looking for some help please 😊 I am trying to figure out week over week percent change by Supplier or department in separate tables not a graph as I was able to get that with a dates table...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.