5 Year Rolling Average DAX

[Anonymous]

Hi Experts

How could i modify the following DAX Measure to work out the year rolling average..

[Seanan · Accepted solution]

Hi @Anonymous,

Could you please try this:

5 Year Rolling Avg = AVERAGEX(DATESINPERIOD('Dates'[Date],LASTDATE('Dates'[Date]),-5,YEAR),[Total Sales])