Forum Discussion
Solved
Rolling 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 b...
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
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?
Are you using the Primary date column from the table ? Do you have this table connected to a calendar table ?
I am using the date column from my table. I dont have a calendar table involved. Data set looks like this