Forum Discussion
Helper IRolling 7 Days Average
Hi All,
I have a dataset which starts on 4th Jan 2021. What I want to do is show the rolling 7 day average for each of these dates so for example 12/02/2023 i want to know what the average has been over the last 7 days, and on 11/02/2023 the average over the last 7 days of that date etc etc. I have attached my sample file, if anyone could help that would be great.
https://drive.google.com/file/d/1cj5I_RJI9mOSHyC7iR-s2OVUkN_6ShCM/view?usp=sharing
I have made a Tutorial to show the rolling average. From the dropdown you can select days and follow the tutorial.
Calculate Dynamic Rolling Average in PowerBI using a Slider
Regards
Mohammed Ismail
5 Replies
miTutorialsSuper User
I have made a Tutorial to show the rolling average. From the dropdown you can select days and follow the tutorial.
Calculate Dynamic Rolling Average in PowerBI using a Slider
Regards
Mohammed Ismail
Abz_17Hi thanks for getting back to me. I am getting this error coming up with your method
Im not sure if it is because my values are set as percentages and not a whole number.
- Abz_17
Hi, I tried the solution but am getting this error
says it cant display visuals due to the error above. Is it to do with my data? Or something else?
- miTutorials
Are you using the Primary date column from the table ? Do you have this table connected to a calendar table ?