7 Day Moving Average

 Sales 7-Day Moving Average =

VAR StartDate = DATEADD(LASTDATE('Date'[Date]), -6, DAY)

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

 

RETURN

 

AVERAGEX(

DATESBETWEEN(

'Date'[Date],

StartDate,

EndDate),

[Total Sales])