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