Getting data for two months back

[matt_s]

I thought this was supposed to ber very easy. I have a super simple table looking like the picture below. I want to programmatically get the value three months back in time. I.e. August value if we are in November. 

Basically I want to get the value of Purchases but filtered on month = currentmonth - 3. 

This should work?

CALCULATE(MAX(Table[Purchases]); DATEADD(Table[Date].[MonthNo]; -3; MONTH))

[matt_s · Accepted solution]

Removing the bold marked text below solved this issue...

CALCULATE(MAX(Table[Purchases]); DATEADD(Table[Date].[MonthNo]; -3; MONTH))