Rolling Average of a Measure

DAX DAX Calculations
1

Hi,

I have a measure that creates my forecast accuracy. I want to be able to view my results as a 12 month rolling average in a line chart. I can create this in a table using the below formula:

AME 12 Mth Avg = 
AVERAGEX(
	KEEPFILTERS(VALUES('Historic_Index'[Forecast Date])),
	CALCULATE('Accuracy Calcs'[AME this month]))

This allows me to use filters to limit the table to the last 12 months and it will give me a single figure for the latest 12 month average. This does not however allow me to see the rolling average over a period of time - I want to see how it has moved as the year has progressed - I have attempted to do this but no method I have found allows me to apply a rolling average method to a measure - just to a column. Is there a way around this?

2

Have you check out the rolling average total technique here?

You can sub in any measure here, it doesn’t have to be a column at all.