Skip to main content
DAX in Power Pivot

Essential DAX Functions and Concepts

You may find working with unstructured data a challenge. It is hard to quantify without consistency. You will find real benefit in using the Power Pivot tool to structure your data, using its the formula language Data Analysis Expressions, or DAX. In this course, you’ll learn the basic functions of DAX.

Intermediate        12 Lessons        120 Minutes        CPD Credits
Start Today

About This Course

If your company has been storing data in an unstructured way for some time, cleaning and transforming it can be a drain on your precious time. Power Pivot’s DAX can help. Here, you’ll learn why Power Pivot needs its own formula language and how to apply it.

Across 12 lessons, you’ll explore DAX’s aggregate and logical functions, as well as how it works with integers and text.

By the end of the course, you’ll understand the differences between DAX and Excel functions, and know how to apply what you need to your own datasets.

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. Introduction to DAX
2. Calculated Columns and Measures
3. Creating New Tables and Relationships
4. Aggregate Functions
5. The Calculate Function
6. Introduction to Logical Functions

Read More

7. Refining Logical Functions
8. The Switch Function
9. Ranking Data
10. Count Functions
11. Searching Text Strings
12. Splitting and Combining Text Strings
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