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

Hey there!

Try this:

MoM Revenue Growth = 
VAR _Actual = 
    Total
VAR _PrevMonth =
    CALCULATE(
        Total,
        PREVIOUSMONTH( YourDateColumn )
    )
RETURN
    _Actual - _ PrevMonth

Let me know if that helps!

Anonymous's avatar
Anonymous
Not applicable
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)).

      • tamerj1's avatar
        tamerj1
        Community Champion
        3 years ago

        Anonymous 

        You have a space before PrevMonth. Delete it