DAX: From Fundamentals to Advanced Insights

SESSION TOPIC: DAX: From Fundamentals to Advanced Insights

HIGH LEVEL AGENDA:
#1. Settle in & Intros
#2: Fabric and Power BI Updates
#3. DAX: From Fundamentals to Advanced Insights Live Demo
#4. Q&A / Close

LEARNING OBJECTIVES:

• ✅ Iterators & Conditional Logic – When to use SUMX vs. SUM, SWITCH vs. IF, and best practices for writing efficient queries.
• ✅ CALCULATE & Time Intelligence – How to modify filter context, shift dates dynamically, and work with multiple date fields.
• ✅ Disconnected Date Tables – When inactive relationships won’t work and how to use disconnected tables for better slicing.