Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Week over Week Change

    I have been trying to figure out how to get week over week change to display on a table or matrix.  Below are pictures of what the matrix looks like and a sample of the data used. I have calcul...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

 

Thank you, v-yulgu-msft.  I saw those before posting my question but was unable to translate them to my data.  I may be able to use the formula below, however I am not trying to find percentage change.  First, I would probably need someone to break down each part of the formula so I understand what it is doing.  Second, the final part of the formula seems to be figuring the % change over the previous week.  How would that part change to give me just week over week change in numbers, not percentage change.  

 

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 )
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 



 How would that part change to give me just week over week change in numbers, not percentage change.  

Measure =
VAR lastWeekAmount =
    CALCULATE (
        SUM ( Append1[Video Views] ),
        FILTER (
            ALL ( 'Calendar' ),
            'Calendar'[WeekNum]
                = MIN ( 'Calendar'[WeekNum] ) - 1
        )
    )
RETURN
   SUM ( Append1[Video Views] ) - lastWeekAmount

Regards,

Yuliana Gu