Forum Discussion

webward3's avatar
webward3
New Member
9 years ago

Previous Month Measure

I have a date table joined to my fact table. I'm trying to create a previous month measure in my tabular model. When I use the following formula referencing my date table, I get the exact same measur...
General Comment
Sean's avatar
Sean
Community Champion
9 years ago

Using your Measure 2

Create this Measure

Previous Month Measure =
CALCULATE ( [Measure 2], DATEADD ( DATESMTD ( DimDate[Date] ), -1, MONTH ) )

or this should also work

Previous Month Measure =
CALCULATE ( [Measure 2], PARALLELPERIOD ( DimDate[Date], -1, MONTH ) )
Sean's avatar
Sean
Community Champion
9 years ago

What is the range of your Calendar Table?