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 (i.e Supplier 1, Supplier 2 – % change from previous week).

What I am encountering is totals in the table returning the same values. Would any one be able to help me with this please.

 

I was able to display this in a chart using the below dax (Screen shot highlighted below), but want to see it in a table or matrix table.

 

Measure =

VAR lastWeekAmount =

    CALCULATE (

        SUM ( Append1[Video Views] ),

        FILTER (

            ALL ( 'Calendar' ),

            'Calendar'[WeekNum]

                = MIN ( 'Calendar'[WeekNum] ) - 1

        )

    )

RETURN

    DIVIDE (SUM (Append1[Video Views] ) - lastWeekAmount, lastWeekAmount, 0 )

 

 

Need Help

2 Replies

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