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!
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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        tamerj1 

        Hi, the equation is working now but it only gives the sum of latest month data, I believe shuld be the PREVIOUSMONTH setting not working probaly, any advice on this? 

         

        Or can this criteria set as calculate the sum of the value except a sepecific date? Will that be easier? 

         

        Thanks!