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!
NyeinChan's avatar
NyeinChan
Regular Visitor
3 years ago

You can use either time intelligence build in function or just create common dimension column (i.e. month for you) and create a measure calculating sale difference based on current vs previous period.