Rolling 7 Days Average

[Abz_17]

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 

[miTutorials · Accepted solution]

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

www.youtube.com/MiTutorials

[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 ?

[Abz_17]

I am using the date column from my table. I dont have a calendar table involved. Data set looks like this

[Abz_17]

Hi 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.