Forum Discussion

hyggins's avatar
hyggins
Icon for Helper I rankHelper I
7 years ago
Solved

Incorrect Measure Total - subtracting between two Month over Month measures

Hello,   I'm trying to get my Total Changes measure to calculate correctly. I'm using a matrix visual. Red is what I get currently, Green is the desired total. Year Month This Month Last Mon...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    hyggins try to change your measure like below and then it should work and total of your monthly variance will be correct.

     

    Last Month = 
CALCULATE(
[This Month],
DATEADD( DimDate[Date], -1, MONTH )
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

hyggins try to change your measure like below and then it should work and total of your monthly variance will be correct.

 

Last Month = 
CALCULATE(
[This Month],
DATEADD( DimDate[Date], -1, MONTH )
)
  • hyggins's avatar
    hyggins
    Icon for Helper I rankHelper I
    7 years ago

    parry2k Wow! That did it! Thank you so much!

     

    I'm going to have to dig into the nuances of PREVIOUSMONTH vs DATEADD to see what the differences are. 

     

    Thanks again!

     

    Grant