Forum Discussion
Solved
13 Week Rolling Average Graph with Daily %
After looking at some examples previously posted, I still cant figure out how to implement this seemingly easy concept into my PowerBI report. My dataset only includes the columns: [Date], and ...
Hi,
Try this
- Create a calendar table which should have all dates that exist in your dataset. There should be no repetitions in the calendar table and no date should be missed either
- Create a relationship from the Date column of your data table to the date column of your calendar table
- In your visual, drag the date field from the calendar table
- Write the following measures
Success rate = SUM(Data[Success%])
13 week average success rate = CALCULATE([Success rate],DATESBETWEEN(Calendar[Date],MIN(Calendar[Date])-91,MIN(Calendar[Date])))
Hope this helps.
Thanks for the reply. After trying your suggestion, I still could not manage to get this to work. When I add your new 13 weeks measure to the graph it shows the exact same as the daily % (see the inlcuded screenshot.) Your idea is exactly what I was looking for, I just cant make it work.
Hi,
Share the link from where i can download your file.