Duration: 120 Minutes
Audience: Power BI users, analysts, and data professionals
Skill Level: Beginner to Intermediate
This 90-minute session introduces participants to Data Analysis Expressions (DAX), the powerful formula language in Power BI. You’ll learn the fundamentals of calculated columns, measures, and aggregation functions while exploring the difference between row context and filter context. Through hands-on exercises and real-world use cases, this session will help you write efficient DAX formulas to perform calculations, manipulate data, and create dynamic reports.
1. Introduction to DAX
- What is DAX and why is it important?
- Key differences between Calculated Columns and Measures
- How DAX works within Power BI’s data model
2. Understanding DAX Evaluation Context
- Row Context vs. Filter Context – Why it matters
- How context affects calculations in different visuals
- Introduction to the CALCULATE function and modifying filters
3. Hands-on DAX Demonstration
- Creating Calculated Columns vs. Measures – Best practices
- Using CALCULATE for dynamic filtering
- Writing a basic time intelligence formula (e.g., Year-to-Date sales)
- Implementing dynamic percentage calculations
4. Advanced DAX Concepts (Intro Level)
- ALL and FILTER Functions – Controlling context
- RELATED and RELATEDTABLE – Working with relationships
- Understanding Variables (VAR) for clean DAX code
5. Real-World Applications & Best Practices
- Common mistakes and how to debug DAX formulas
- Optimizing performance – Avoiding row-by-row calculations
- How to approach DAX for different reporting scenarios
6. Q&A and Wrap-Up
- Open discussion on real-world DAX challenges
- Additional resources and next steps for mastering DAX
Extra Subject: Core DAX Functions
- Aggregation Functions – SUM, AVERAGE, MIN, MAX
- Logical & Conditional Functions – IF, SWITCH
- Text Functions – CONCATENATE, LEFT, RIGHT, FIND
- Date & Time Functions – TODAY, NOW, YEAR, MONTH
By the end of the session, you’ll be confident in using DAX to enhance your Power BI reports and unlock deeper insights from your data.
