Time based moving average with multiple variables

[LevIT]

Hi All,

I would like to make a moving average (say 7 day) for the water prodcution over time for each well I have. This will help me despike the data and also calculate things like max rate more accurately.

Can someone please help? Also because my project is direct query I dont think I cna use calculate function?

TIA

Levi

[amitchandak]

@LevIT , a measure like

Rolling 7 Day = calculate(AverageX(Values('Date'[Date]),CALCULATE(sum(Sales[Sales Amount]))),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-7,Day))