Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

calculating difference

Hi,

 

I am stucked with the following question.

 

Product CodeSales Date
A1001/02/2022
B1001/02/2022
C1001/02/2022
D1001/02/2022
A1001/03/2022
A1001/03/2022
B1001/03/2022
C1001/03/2022
A1001/04/2022
B1001/04/2022

 

I would look for a equation that can calculate the difference between two period of time. In this data set every month I will update the sales record and I need a measure that can gives me somthing like below:

 

Assume today is Apr:

Product CodeTotal SalesDifference vs Last month
A4010
B3010
C200
D100

 

What I need is the measure that can complete "Difference vs Last month" at the same time it does not require filter on visualization.

 

I can do this by using two spreadsheet inside powerBI, however, I hope this can be on 1 spreadsheet so everytime I dont have to refresh two file.

 

Is there any way to do this?

 

Thank you!

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

9 Replies

  • 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.

     

  • 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