Forum Discussion
Calculating Same Period Last Month !!!
Hi Geniuses, I have created a measure to calculate MTD sales of my product category now I want to calculate sales of same premiod last month to compare. My Dax formula is returning the same resu...
Tanushree_Kapse
Impactful Individual
Impactful IndividualHi Anonymous ,
Try this measure:
PREMIUN SPLM=
CALCULATE([MTD PREMIUM Sales],
PREVIOUSMONTH(DATESMTD('Calendar'[Date])))
Mark this as a solution if I answered your question.
Kudos are always appreciated.
Thanks
Hi Tanushree_Kapse,
It didn't work either. Returned the same value as current month.
Thanks