Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Missing dates for 4days Moving Average

Hi I am trying to find the moving average for a data sets with missing data but I am having hard time getting an accurate averages. I did create a date table on the power query side and merge it wit...

Tips and Tricks

Tutorial Requests

amitchandak
5 years ago
Anonymous , Try like

Rolling 4 = CALCULATE(AverageX(values('Date'[Date]),[Revenue]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-4,Day))

Icon for Super User rank

Super User

5 years ago

Anonymous , Try like

Rolling 4 = CALCULATE(AverageX(values('Date'[Date]),[Revenue]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-4,Day))