Calculate average of specific months

[KikiLondon]

Hi 

I have a dataset for number of accidents in various regions for the last 3 years. I want to calculate the averag number of accidents from the last 3 months but excluding the current month. 

e.g. we are in February 2022, therefore I want an average of accidents for Jan 22', Dec 21' and Nov 21'. 

[KikiLondon]

Thanks @amitchandak! It worked perfectly! 

[amitchandak · Accepted solution]

@KikiLondon , try a measure like

Rolling 3 = calculate(AverageX(Values('Date'[MONTH Year]),CALCULATE(sum(Sales[Sales Amount]))),DATESINPERIOD('Date'[Date ], eomonth(MAX('Date'[Date ]),-1) ,-3,MONTH))