Rolling Average between two dates

[#1]

I'm trying to create a rolling average of dates between last month and two moths ago. What I'm doing is:

=avg({<MonthYear={">=$(=Date(addmonths(Max(MonthYear), -2),'MMM-YYYY'))

<=$(=Date(addmonths(Max(MonthYear), -1),'MMM-YYYY'))"}>}[Order Cost])

What this seems to do is, give me an average of any month up until last month, so as if the first portion of the set analysis is completely ignored.

Any idea what I'm doing wrong there?

[marcus_sommer · Accepted solution]

I think this will be helpful: Calculating rolling n-period totals, averages or other aggregations

- Marcus