Forum Discussion

Anonymous's avatar
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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 

It work if you revenue is a column in the same table. I guess the problem is your [revenue] is a measure calculated based on the relationship between the tables. If you can just share the sample pbix, we should able to detect the issue. 

 

Paul Zheng _ Community Support Team