Introduction to DAX for Power BI

Trained 50k+ People

Over 100+ Countries

By Specialist Trainers

With Over 20 Years' Experience

Enquire Now
Book Now
Download Overview

By the end of this course, learners will be able to understand DAX syntax and evaluation context, create calculated columns and measures, use common DAX functions such as SUM, CALCULATE, FILTER, and RELATED, apply basic time intelligence functions, and build reusable calculations that improve data analysis and reporting in Power BI. These skills enable learners to create more dynamic and insightful Power BI reports.

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
Implicit measures
Adding quick measures
Working with DAX data types .
Doing basic math
Using logic in your calculations
Using the if() function
Nested if()
Using the switch() function
Advanced switch()
Logical operators & functions: ||, OR(), &&, AND(), NOT()
Aggregating and summarizing data
The sum() function

Module 3: Working with context in the data model

Context defined
Data modeling basics
Introduction to dimensional modeling
Relationships and their effect on the evaluation context
Getting data from other tables using related() and related table
Looking up data without using relationships
Modifying the context using calculate()

Module 4: Performing more advanced calculations

The DAX iterator functions
Using table manipulation functions

Module 5: Working with time

Performing date calculations
Working with date tables
Generating a date table with the calendar() function
Defining custom operating periods
YTD, QTD, and MTD calculations
Custom to-date calculations
Finding year-over-year change
Finding moving averages

Module 6: Enhancing the user experience

Controlling visibility of your measures
Using what-if parameters
Adding banding
Using DAX to provide row-level security

Power BI users, data analysts, business analysts, report developers, and professionals working with data models and dashboards

Instructor-led training, course materials

Basic knowledge of Power BI Desktop, data modeling fundamentals, and Excel formulas

Microsoft Learn: DAX in Power BI

This course includes a practical assessment to evaluate learners’ understanding of DAX fundamentals. The assessment focuses on creating measures, applying evaluation context correctly, and solving common analytical problems using DAX. Learners may be required to complete hands-on exercises or a short project within Power BI to demonstrate applied DAX skills.

No Exam

Certificate of Completion: DAX Fundamentals for Power BI

After completing this course, learners can progress to Advanced DAX, Power BI data modeling, performance optimization, or Microsoft Power BI certification preparation.

Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.

Why Choose Us?

We Are Here To Help You Pass

All of our trainers have achieved exceptionally high delegate pass rates for accredited examinations for all our courses. We also offer complimentary pre and post-course support for any questions you may have.

We Are Flexible

We try and be as flexible as we can and accommodate your needs. We can swap delegates at any time with no charge. We can also create bespoke content should this be required.

We Are The Specialists

We specialise in IT Service and Project Management. All of our Trainers and Consultants have considerable years of hands-on experience in IT Service / Project Management, working across a wide number of industry sectors.

We Are Professionals

Our training, sales and admin staff are all professional, helpful, friendly and approachable. We believe in providing excellent customer service. You will always have a dedicated friendly Account Manager

Reviews

Purple Griffon recently delivered 2 service management courses for the MOD and we all found it to be a very positive experience. The Company is very professional, with extremely knowledgeable and experienced trainers, who have real world skills.

Garry Jones - Procurement Manager, MOD

It was a beast of a course but very rewarding. Thanks for the assistance around the booking - the customer service was excellent. I no longer have to hide behind my project management team and can say loud and proud I am a PRINCE2® practitioner!

Matthew Slater - Service Delivery Manager, InTechnology

The training was organised well, administrative help was quick and relevant which made the information gathering and training preparations fast & easy. The trainer was knowledgeable and experienced. We’ve received very good feedback.

Karolina Manka - Training Specialist, Accenture

I passed! which I must admit was 100% down to your trainer Bob. He gave us enough stories and tips to get me through it and sometimes the stories sink in better than anything else. Thanks again, I'd definitely use your company again because of him.

Tracy Iqbal - IT Assistant, MacRoberts

Feedback from staff has been positive and you have helped us to effectively embed the ITIL® framework into our working processes and achieve key organisational goals. We look forward to continuing with rest of our ITIL® courses throughout the year.

Max Khalid - ITSM Specialist, London Programme for IT

I have self-funded several courses with Purple Griffon, and passed all of my exams to gain ITIL® Expert accreditation. This wouldn't have been possible without the help from the team and tutors. This makes Purple Griffon my first choice of training provider.

Sarah Jamieson - Individual , Self-Funded

Excellent course material and exercises and discussion facilitate learning in the classroom. Managed to pass all exams of courses taken with Purple Griffon! And I believe on this latest course a 100% pass rate from all delegates on the course!

Rob James - Individual, Self-Funded

Great company and Steve is a really knowledgeable guy as well!

Maurits Van Der Plas - Director, Van Haren Learning Solutions

I could not find any other training exclusively focused on the IT SDM roles and responsibilities elsewhere, making this course possibly the best IT SDM training in the world! I consider this course among the top courses I've had the pleasure of attending.

Michael Hilliker - IT Branch, Gouvernement Du Canada

The free "Introduction To The World Of The Service Desk" provided a great insight into the world of IT Service Management. Excellent slides.

Chinonyerem Mpamah - Learner, Self-Funded

I have been using Purple Griffon since 2013 after taking a course with another company and didn't receive the best experience. Since 2013 I haven't used anyone else. Excellent courses and very personable trainers and high pass rates.

Terry Wilder - Learner, Self-Funded

The Purple Griffon E-Learning study material is very complete, and prepared me for the exam in an excellent way. I am happy to have used the Purple Griffon material and I am planning to do so again in the near future.

Louis Rademaker - Learner, Self-Funded

I've taken classroom training via Purple Griffon and their exceptional team on several occasions. In my case it has been ITIL® based and I can only recommend their services.

David Barrow - Learner, Self-Funded

From what I see the course for CDS is well organised and staff that prepared the materials are really looking for their students to pass the exam with good marks. I wish that whenever I need extra help the staff will help me immediately

Fawaz Yelda - Professional, Control Risks

I got studying material from Purple Griffon and the quality is more than good. Good work!

Sergio Enriquez - Learner, Self-Funded

Very good training provider and the instructor was very knowledgeable

Nigel Rooms - Professional, CDW

Great training - passed my ITIL® exam!

Luca Bakshi - Technical Analyst, Trayport

I found the ITIL® 4 Foundation online training course very good and easy to follow. I think good values.

Keith Brain - Individual, Self-Funded

The Digital Twins Basics Online Workshop (60 Minutes) was simple and the content was easy to understand.

Titilayo Iya Y - Individual, Self-Funded

INFORMATION

Introduction to DAX for Power BI Course Dates

Course

Introduction to DAX for Power BI

Course Date

20 Oct - 21 Oct

Location

Live Online 09:30 - 17:00 (UK Time) Live Online 09:30 - 17:00 (UK Time) Virtual Classroom

Book Now

Enquire Now

Now only £710 710 + VAT

Introduction to DAX for Power BI