Advanced DAX Functions and Concepts
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Using Date Functions
Using Date Functions
DAX provides various functions that allow you to work with the date fields in your data model. We'll see how to identify first and last dates in your data and extract various pieces from a date field.
Adding and Using Date Tables
Adding and Using Date Tables
When you want to use time intelligence functions in DAX, you'll need a date table. We'll see why date tables are needed, what they generally contain, and how to add them to the data model.
Time Intelligence Analysis
Time Intelligence Analysis
In this lesson, we'll look at common time intelligence functions. We'll see how to add time to a date field, find the difference between two dates, and how to group dates on a monthly or quarterly basis.
Working with Variables
Working with Variables
Introduced in 2015, variables allow you to make long DAX formulas much easier to write and read. We'll see how to create variables in this lesson.
Using Relational Functions
Using Relational Functions
DAX has two relational functions, allowing you to use data from one table in a calculation in another table. We'll see both functions in this lesson.
Applying the Filter Function
Applying the Filter Function
Filtering is a very important concept in DAX. In this lesson, we will look at the Filter function, and use it in a Calculate function on a subset of our data
Other Filtering Functions
Other Filtering Functions
In this lesson, we will look at the remaining filtering functions in DAX, including the important All function as well as functions such as Values and Distinct
Understanding the Row Context
Understanding the Row Context
In DAX, we don't refer to individual rows in our formulas, unlike Excel. In this lesson, we'll see how the row context tells DAX which rows
Multiple Row Contexts
Multiple Row Contexts
Sometimes a DAX formula can have more than one row context. We'll see what problems this can cause and how you can solve those problems in this lesson
Understanding Filter Contexts
Understanding Filter Contexts
The filter context seems simple, but is possibly the most advanced concept in DAX. We'll see how it works and what you need to be careful of when dealing with filter contexts.
Context Transition in Power Pivot
Context Transition in Power Pivot
The Calculate function is capable of changing a row context into a filter context. We'll see the effect of this transition, and find out when it occurs in this lesson.
