Course Overview
How much more could you do with Power BI if you could create your own custom calculations?
DAX is considered a foundational skill for unlocking advanced analytics and custom reporting in Power BI, according to Microsoft and industry experts. Mastering DAX lets you move beyond basic visuals and deliver data-driven insights your organization can rely on.
Introduction to DAX for Power BI is a two-day, instructor-led course for business users ready to unleash the full power of their data models. You’ll learn practical DAX skills to solve real business problems: write your own calculated columns, measures, and tables; visualize how Power BI computes DAX; and confidently troubleshoot and refine your calculations. The course blends essential theory with hands-on practice, so you’ll understand not just the “how,” but the “why” behind every calculation.
What Is Included
- Expert-led instruction from certified Power BI and DAX professionals
- Digital courseware and step-by-step lab exercises
- 90-day access to class recordings
- Flexible rescheduling
Course Objectives
- Describe DAX syntax, data types, and errors
- Use DAX to create calculated columns, measures, and tables
- Explain how DAX calculations are evaluated, along with the differences between row context and filter context
- Configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.
- Create calculated columns and measures that use data from multiple tables in the data model
- Write measures that handle error conditions gracefully
- Use DAX to enhance the Power BI user experience
- Use DAX Studio to connect to a Power BI data model and execute simple queries
Who Should Attend?
This course is ideal for business users and analysts who have been using Power BI for reports and dashboards and want to take their analytic solutions to the next level. Learning DAX is a natural next step for experienced Power BI users looking to unlock more advanced data modeling and analysis capabilities.
Course Prerequisites
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands-on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor-Led (the best training format we offer)
- Live Online Classroom – Online Instructor-Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 12/8/2025 | 12/12/2025 | ||||
| 12/29/2025 | 1/2/2026 | ||||
| 1/19/2026 | 1/23/2026 | ||||
| 2/9/2026 | 2/13/2026 | ||||
| 3/2/2026 | 3/6/2026 | ||||
| 3/23/2026 | 3/27/2026 | ||||
| 4/13/2026 | 4/17/2026 | ||||
| 5/4/2026 | 5/8/2026 | ||||
| 5/25/2026 | 5/29/2026 | ||||
| 6/15/2026 | 6/19/2026 | ||||
| 7/6/2026 | 7/10/2026 | ||||
| 7/27/2026 | 7/31/2026 | ||||
| 8/17/2026 | 8/21/2026 | ||||
| 9/7/2026 | 9/11/2026 | ||||
| 9/28/2026 | 10/2/2026 | ||||
| 10/19/2026 | 10/23/2026 | ||||
| 11/9/2026 | 11/13/2026 | ||||
| 11/30/2026 | 12/4/2026 | ||||
| 12/21/2026 | 12/25/2026 | ||||
| 1/11/2027 | 1/15/2027 |
Agenda
Duration
2 Days
Module 1 – Getting started with DAX
- Introduction to DAX
- Creating objects with DAX
- Context and rules of evaluation
- Variables, comments, and testing
Module 2 – Performing basic calculations
- Getting started with calculations
- Implicit measures and adding quick measures
- Working with DAX data types and basic math
- Using logic in calculations: IF(), nested IF(), SWITCH(), advanced SWITCH(), logical operators and functions (OR(), AND(), NOT())
- Aggregating and summarizing data with the SUM() function
Module 3 – Working with context in the data model
- Understanding context, data modeling basics, and dimensional modeling
- Relationships and their effect on the evaluation context
- Getting data from other tables: using RELATED(), RELATEDTABLE(), and looking up data without relationships
- Modifying context using CALCULATE()
Module 4 – Performing more advanced calculations
- DAX iterator functions
- Table manipulation functions
Module 5 – Working with time
- Performing date calculations and working with date tables
- Generating a date table with CALENDAR()
- Defining custom operating periods
- YTD, QTD, MTD, and custom to-date calculations
- Finding year-over-year change and moving averages
Module 6 – Enhancing the user experience
- Controlling measure visibility
- Using what-if parameters and adding banding
- Providing row-level security using DAX
