In this detailed walkthrough, I address the challenge of calculating rolling 3-month averages in Power BI with a disconnected date table.

Watch as I explain each step, from setting up the date table, troubleshooting problems, down to filter/row context and writing the final DAX measure, ensuring you can apply these techniques to your own data models.