Introduction to DAX
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Creating Calculated Columns
Creating Calculated Columns
Calculated columns let you add new columns to the tables in the data model. Learn how to create these new columns in this lesson.
Creating and Using Measures
Creating and Using Measures
Measures are calculations that can be added to the data model. In this lesson, we'll create some new measures and learn when to create a measure and when to create a column.
Creating Calculated Tables
Creating Calculated Tables
You can add a new table to the data model in Power BI using DAX formulas. In this lesson, we'll create a new table and create a relationship with the existing table.
Aggregation Functions
Aggregation Functions
Aggregate functions, such as SUM, AVERAGE, MIN, MAX and so on, calculate a simple formula over a column of data. We'll look at some of the most common aggregate functions in this lesson.
Using the Calculate Function
Using the Calculate Function
Calculate is almost certainly the most powerful function in DAX. It filters the dataset and evaluates another formula, in one function. We'll introduce Calculate in this lesson.
Introduction to Logical Functions
Introduction to Logical Functions
Logical functions, such as IF statements, allow you to test conditions. DAX's conditional functions work very similarly to those of Excel, as we will see in this lesson.
Complex Logical Functions
Complex Logical Functions
In this lesson, we continue looking at conditional functions, seeing how you can build more complex conditions using the AND and OR functions.
The Switch Function
The Switch Function
Testing many conditions using IF statements can quickly become difficult to read. The Switch function provides an alternative that is much easier to understand.
The RankX Function
The RankX Function
Ranking things is a very common business task. Learn how to do it in this lesson using the RankX function.
Count and Distinctcount
Count and Distinctcount
Two of the major count functions in DAX are Count and DistinctCount. In this lesson, we will see both and learn the difference between the two.
Extracting Text Strings
Extracting Text Strings
Working with text data is another common business task. In this lesson, we'll see several ways to find a particular string within a text field.
Combining and Splitting Text Fields
Combining and Splitting Text Fields
Continuing our look at text functions, we will see how to combine and split columns of text data.
