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

[Anonymous]

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 )

[amitchandak]

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

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.