Forum Discussion
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 ...
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))