Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I think this will be helpful: Calculating rolling n-period totals, averages or other aggregations
- Marcus
I think this will be helpful: Calculating rolling n-period totals, averages or other aggregations
- Marcus