Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 with my data but for some odd reasons the average is not including the missing dates.
This is what Power Bi is showing:
But when I did it in Excel, I got the correct moving 4 days average:
Please any assist or help is greatly appreciated.Thank You!
Solved! Go to Solution.
@Anonymous , Try like
Rolling 4 = CALCULATE(AverageX(values('Date'[Date]),[Revenue]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-4,Day))
@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
@Anonymous , Try like
Rolling 4 = CALCULATE(AverageX(values('Date'[Date]),[Revenue]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-4,Day))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |