Introduction to DAX for Power BI

Name: Introduction to DAX for Power BI
Price: 1295.00 USD
Availability: InStock
Rating: 4.5 (1200 reviews)

Price
$1,295.00 USD

Duration
2 Days

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information

Download Course Details

Course Details Only
Course Details & Schedule

Skip to Class Dates

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
Free course retake option (see conditions)

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.

Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

What is Introduction to DAX in Power BI? Is it worth it?

Introduction to DAX for Power BI is a two-day hands-on course that teaches you how to use Data Analysis Expressions (DAX) to build custom calculations, solve real business problems, and create more insightful reports in Power BI. DAX skills are highly valued, Power BI professionals with DAX expertise often command higher salaries and are in demand for advanced analytics projects.

How will learning DAX help me write DAX formulas and calculations in Microsoft Power BI?

You’ll gain the skills to write DAX formulas for calculated columns, measures, and custom tables in Power BI. This empowers you to perform deeper analysis, automate calculations, and create dynamic reports, moving beyond what’s possible with basic tools.

How does this course help experienced Power BI users use DAX to create custom calculated columns and measures in a data model?

This course guides experienced Power BI users through the process of using DAX to create custom calculations, build calculated columns, and enhance the data model. You’ll learn to solve real business problems and tailor analytics to your organization’s needs.

Does Introduction to DAX for Power BI prepare me to write and understand complex DAX code and data analysis expressions?

Yes, this course covers everything from DAX basics to more complex DAX code and expressions. You’ll develop confidence in writing and understanding DAX calculations used in advanced Power BI data analysis.

Is there a certification associated with this course?

While this course focuses on hands-on DAX skills and is not directly tied to a specific certification, it provides a strong foundation for advanced Power BI certifications and roles that require DAX expertise.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

Corporate Tech Pass: Our Corporate Tech Pass includes unlimited attendance for a single person, in the following Virtual Instructor Led course types: Microsoft Office, Microsoft Technical, CompTIA, Project Management, SharePoint, ITIL, Certified Ethical Hacker, Certified Hacking Forensics Investigator, Java, Professional Development Courses and more. The full list of eligible course titles can be found at https://www.newhorizons.com/eligible.

If you have questions about our Corporate Tech Pass, please contact your Account Manager.

Course Prerequisites

Introduction to Power BI, Power BI: Hands-On Reports and Dashboards, Power BI: Advanced Data Modeling and Shaping or equivalent working experience.

Agenda

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()