Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Week over Week change %

Hello,   I need to calculate Week over Week change %.    i write the following DAX but red highlighted one has Error.   How should  i change the expression?     Week change = VAR lastweek...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Please use the below formula 

     

    Measure =
VAR lastWeekAmount =
    CALCULATE (
        SUM ( Value Sum),
        FILTER (
            ALL ( 'Calendar' ),
            'Calendar'[WeekNum]
                = MIN ( 'Calendar'[WeekNum] ) - 1
        )
    )
RETURN
    DIVIDE ( SUM ( Value Sum ) - lastWeekAmount, lastWeekAmount, 0 )

     

     

    Regards,

    Gaurav  Raj Singh

     

    LinkedIN : https://www.linkedin.com/in/gauravrajsingh/

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Please use the below formula 

 

Measure =
VAR lastWeekAmount =
    CALCULATE (
        SUM ( Value Sum),
        FILTER (
            ALL ( 'Calendar' ),
            'Calendar'[WeekNum]
                = MIN ( 'Calendar'[WeekNum] ) - 1
        )
    )
RETURN
    DIVIDE ( SUM ( Value Sum ) - lastWeekAmount, lastWeekAmount, 0 )

 

 

Regards,

Gaurav  Raj Singh

 

LinkedIN : https://www.linkedin.com/in/gauravrajsingh/

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you very much for your help^^

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous 

       

      it worked ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Yes it worked^^ Thanks you

         

        By the way, i need to show Week sales as following

         

        In this case i need to calculate This week sale and last week sale.

         

        would you help me Dax for those?

         

        Thank you very much again.