Skip to main content
The Query Editor and DAX

Introduction to DAX

Ensure you are making the most of Power BI’s Query Editor. Learn how to make complex demands of your data using Power BI’s simple and intuitive formula language, DAX or Data Analysis Expressions

Intermediate        12 Lessons        120 Minutes        CPD Credits
Start Today

About This Course

As your business needs grow more complex, so too will your queries in Power BI. Learn how to combine DAX functions to ensure your queries are as effective as possible.

You will learn how to create calculated columns and measures using DAX. You’ll be introduced to some common conditional functions like AND and OR. You will also learn how to combine and split columns of data using DAX.

By the end of this course, you will have the basic building blocks to construct complex DAX formulas to vastly improve your data analysis capabilities in Power BI.

Start Today

Learning Outcomes

  • Create calculated columns and measures using DAX
  • Create new tables in the data model
  • Use aggregate functions like SUM and AVERAGE
  • Use the CALCULATE function
  • Use logical functions such as IF, AND, and OR
  • Create categories with the SWITCH function
  • Create ranks within your data
  • Use DAX’s text functions


1. Creating Calculated Columns
2. Creating and Using Measures
3. Creating Calculated Tables
4. Aggregation Functions
5. Using the Calculate Function
6. Introduction to Logical Functions

Read More

7. Complex Logical Functions
8. The Switch Function
9. The RankX Function
10. Count and Distinctcount
11. Extracting Text Strings
12. Combining and Splitting Text Fields
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world

Close Menu