How to Calculate Rolling 3-Month Average in Power BI with Disconnected Date Table

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.

🎥 More about Power BI:
- Power BI Tips & Tricks: https://www.youtube.com/playlist?list=PLtYs4yAyAk_9HzJzeSao5-WJSngtW18Kb
- APIs in Power BI: https://www.youtube.com/playlist?list=PLtYs4yAyAk_87e3a-dGUOaFP9b1uDMtWm
- Analytics in Power BI: https://www.youtube.com/playlist?list=PLtYs4yAyAk_9bQ0ZoGDT98LMNDqD9sWP4
- Deneb in Power BI: https://www.youtube.com/playlist?list=PLtYs4yAyAk_-4wgikQ45zmddKg2b2ZTDk

🔗 Resources:
SQLBI Article: https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/

🕒 Timestamps:
00:00 - Intro
00:42 - Problem Breakdown
01:18 - Date Table Setup
01:58 - Disconnected Date Table Creation
03:13 - Relationship Management
04:15 - Initial Measure and Filter Context
07:43 - Advanced Measure Calculations
10:53 - Using Date and Period Functions
16:15 - Troubleshooting Measure Calculations
21:14 - Final Adjustments and Testing
24:03 - Conclusion

#PowerBI #DataAnalytics #DAXMeasures #BusinessIntelligence #IntrovertedManager #DAX

___
Music: Bensound
License code: DABNGVEHVUOGWUZQ

Видео How to Calculate Rolling 3-Month Average in Power BI with Disconnected Date Table канала Maxim Anatsko – Power BI, Fabric & Analytics