Forum Discussion

LevIT's avatar
LevIT
New Member
4 years ago

Time based moving average with multiple variables

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

 

 

 

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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))