Advanced DAX Function and Concepts
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
Course Introduction
Course Introduction
DAX is a powerful formula language, but one that has intricacies that can be tricky to work with. This course outlines what these more advanced topics are and why it’s useful to be aware of them.
Using Date Functions
Using Date Functions
In this lesson, we’ll see how to identify first and last dates in your data and extract various pieces of information 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 a length of 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
Variables allow you to make long DAX formulas much easier to write and read. We’ll see how to create variables in this lesson.
Understanding the Data Model
Understanding the Data Model
In this lesson, we'll learn more about relationship properties and Power BI data model structures.
Applying Cross Filtering
Applying Cross Filtering
Cross filtering can be one of the more difficult aspects of relationships to understand. In this lesson, we’ll learn the difference between single direction and bidirectional cross filtering, and see how filtering can affect visualizations.
Role Playing Dimenstions
Role Playing Dimenstions
Sometimes you might find the need to create more than one relationship between two tables. In this lesson, we’ll explain why this might be the case and how to use the USERELATIONSHIP function to specify which relationship to use in a DAX function.
Using Relational Functions
Using Relational Functions
Having learned about relationships, we can now look at the two commonly used relational functions in DAX. These allow 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 to identify 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. In this lesson, we’ll see how the row context tells DAX which rows to use in a calculation
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
