Forum Discussion

Hinnaxsen's avatar
Hinnaxsen
Frequent Visitor
3 years ago
Solved

Month over Month total

Hello all, I have trouble with the total sum of a Month over Month calculation. This are my Measures: MoM = VAR ValueCurrentPeriod = SUM(TblA[Value]) VAR ValuePreviousPeriod = [Sales PM] VAR ...
Need Help
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago
    _MoM Sales =
    VAR _Prev =
    CALCULATE([Total Sales],PARALLELPERIOD('Date'[Date],-1,MONTH))
    RETURN
    [Total Sales] - _Prev

     

     

    If this post helps, please consider accept as solution to help other members find it more quickly.
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago
_MoM Sales =
VAR _Prev =
CALCULATE([Total Sales],PARALLELPERIOD('Date'[Date],-1,MONTH))
RETURN
[Total Sales] - _Prev

 

 

If this post helps, please consider accept as solution to help other members find it more quickly.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Hinnaxsen's avatar
Hinnaxsen
Frequent Visitor
3 years ago

Thank you very much! It works. Learned something again!