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 generally deal with $ amount sums and not averaging. This is the formula I've been trying, but it still only shows the monthly average that is already indicated by the columns:
Rolling Average = AVERAGEX(DATESINPERIOD('Date Table'[DATE], LASTDATE('Weekday'DATE]), -30, DAY), AVERAGE('Ticket table'[Days In Progress]))
How can I calculate the 30 day weighted average so I can show it in line form to contrast with the monthly average?
1 Reply
- DataInsights
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/
