Forum Discussion
Calculate 30 day rolling/moving average for another average
I have a line and stacked column chart showing the average days in process for a ticket by month. I want to add a Y-axis line to show the rolling 30 day average, but the resources I've found generall...
DataInsights
Super User
Super User
Here's a great article on moving averages. I recommend creating a measure for Average Days in Progress, and use that measure in the Rolling Average measure. Also, you'll need to clear the date filter context in order to get the last 30 days (the article explains how).
https://www.daxpatterns.com/custom-time-related-calculations/