Trailing 3 Months DAX help needed

[tuktuk]

Hey there,

I'm trying to create a Calculated Measure using OLAP Tools for a pivot whose based is a tabular cube....excel 2016.

here is my formula: CALCULATE([Measures].[Sales Revenue USD],DATESINPERIOD('Date'[Date], EOMONTH(LASTDATE( 'Date'[Date]),0),-3, Month)). i'm getting an error stating not a valid MDX expression.

my overall goal is to get a sum for the trailing 3 months for sale rev.

Thanks

 

[tuktuk]

I figured this one out: Sum(LASTPERIODS(3,[Date].[Month]),[Measures].[Sales Revenue USD])