Moving Average for 4 level indexed values

Hi Anonymous,

Based on my test, you could try this formula:

Column = var a=[index2]-3
return CALCULATE(MAX(_2017[SellingPrice]),FILTER('_2017','_2017'[index2]=a))

Result:

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/ae3sor62pk3mhyt/Moving%20Average%20for%204%20%20level%20indexed%20values.pbix?dl=0

Regards,

Daniel He

Hi Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He