Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 [Success%]
Sample Data:
Date | Success% |
01/01/2016 | 95.12 | ............|............|
05/10/2017 | 97.49 | 05/11/2017 | 96.24 | 05/12/2017 | 95.67 | 05/13/2017 | 98.56 |
............|............|
11/24/2017 | 97.45 |
How would a rolling 13 Week Average be calculated? It does not have to be filterable; just show the last 13 Weeks on a Line Graph Visual, like below. I would like to show the graph below with the Daily% and 13 week Average % together.
This seems like it would be an easy problem....just not for me :).
Any help would be greatly appreciated.
Solved! Go to Solution.
Hi,
Try this
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.
Hi,
Try this
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.
One method would be to create a new column like:
WeeksAgo = WEEKNUM(TODAY()) - WEEKNUM([Date])
Then you could just filter <= 12
Thanks for the quick reply. I was trying to calculate the 13 week Average and then display it on the same graph visual as the daily %. This would help narrow down the dates to only show the 13 weeks, but not the average of the last 13 weeks; unless I misunderstood your usage.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |