Forum Discussion
Calculate Previous Month Value from Dynamic TTM Measure
Hello All, I calcualted TTM using Below measure. VAR CurrentDate = MAX(TTM[Date]) VAR PreviousDate = DATE(YEAR(CurrentDate),MONTH(CurrentDate)-11,DAY(CurrentDate)) VAR Result = CALCULATE...
I guess i got it on my own.
I had to write another measure.
_PreviousMonth TTM =
CALCULATE([_TTM],FILTER(ALLSELECTED(TTM),TTM[Date] <= MAX(TTM[Date])-1))
And it works
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
