3 Month Rolling Average

 3 Month Sales Rolling Average (Values) =

VAR EndDate = LASTDATE('Date'[Date])

 

RETURN

CALCULATE(

CONCATENATEX(

VALUES('Date'[MonthNumberOfYear]),

'Date'[MonthNumberOfYear], ", "), //[Total Sales]),

DATESINPERIOD(

'Date'[Date],

EndDate,

-3,

MONTH))