Forum Discussion
Rolling average slicer
I'm looking for something like a rolling slicer that would allow me to choose a variety of rolling averages of a time series. For example, I'd like to have the option to choose a 5-year rolling average, or a 10-year rolling average (or anything in-between) interactively. Does this exist?
In general, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
2 Replies
Anonymous you have to create the measure and yes it can be achieved.
In general, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
