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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, I have fixed the issue and the equation is now working.

     

    Thank you very much!