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 ,

 

Try this for LastweekSales

LastWeekSales = 

Var ThisWeek = Max(WeekNum)

Return

calculate(sum(sales),WeekNum = ThisWeek - 1)

 

Regards,

Gaurav

Anonymous's avatar
Anonymous
Not applicable
6 years ago

It worked perfect^^😊😊😊😊

 

How about week to date /This week sale/??

 

Thank you, thank you...

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

     

     

    Try this :

    ThisWeekToDate = 

    calculate(sum(sales),WeekNum = MAX(WeekNum))

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago