Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

calculating difference

Hi,   I am stucked with the following question.   Product Code Sales  Date A 10 01/02/2022 B 10 01/02/2022 C 10 01/02/2022 D 10 01/02/2022 A 10 01/03/2022 A 10 ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi, 

    I am not sure what's wrong with my equation as it keep return error message.

     

    MoM Revenue Growth =
    VAR _Actual =
        sum('Table'[Sales])
    VAR _PrevMonth =
        CALCULATE(
            CALCULATE(sum('Table'[Sales])),
            PREVIOUSMONTH ('Table'[Date])
        )
    RETURN
        _Actual - _ PrevMonth
     
    Do you know what I did wrong?
     
    Thanks!
PabloDeheza's avatar
PabloDeheza
Solution Sage
3 years ago

Can you please provide the error message you are getting? Thanks

Anonymous's avatar
Anonymous
Not applicable
3 years ago

The error message is like below:

 

The syntax for 'PrevMonth' is incorrect. (DAX(VAR _Actual = sum(''Table'[Sales])VAR _PrevMonth = CALCULATE( CALCULATE(sum('Table'[Sales])), PREVIOUSMONTH ('Table'[Date]) )RETURN _Actual - _ PrevMonth)).