Mastering DAX Window Functions: Practical Patterns for Real Models (with Tristan Malherbe)

DESCRIPTION 📄
DAX Window functions (released Jan 2023) unlock clean, flexible patterns for ranking, running totals, moving averages, and period comparisons—without messy CALCULATE gymnastics. In this session, we’ll walk through practical use cases using OFFSET, INDEX, and WINDOW to simplify common analytical scenarios over real semantic models.
We’ll cover how to structure window logic, when to use each function, and how to avoid common pitfalls with filters, calendar granularity, and performance. Expect concise examples you can drop straight into production models.

GUEST BIO (Tristan Malherbe) 👤
Founder @Data Pulse | Microsoft Data Platform MVP | Co-Founder Club Power BI & Club Fabric

I speak at both international (Seattle, Portland, Orlando, Dubai, London, Copenhagen, Dublin, Amsterdam) and local conferences (Paris meetup, webinars) about advanced data analysis, modelling and visualization on Power BI.

I co-founded the Club Power BI (The French Power BI User Group, 5,000+ members) in February 2017. We organize meetups in Paris and I regularly run some sessions on Data analytics (Power Query, DAX) and Data visualization.

RELATED CONTENT 🔗
PBIX Link -- https://bit.ly/daxcalculatedcolumns
Twitter --   / datatouille  
LinkedIn --   / tristanmalherbe  
YouTube --    / @tristanmalherbe  

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
Website -- https://analyticendeavors.com
About Us -- https://analyticendeavors.com/about
Our Services -- https://analyticendeavors.com/what-we-do
LinkedIn --   / analytic-endeavors  
Steve's LinkedIn --   / powerbisteve  
Reid's LinkedIn --   / reidhavens  

EMAIL US AT 📧
[email protected]

#PowerBI #DAX #Microsoft #DataModel