Skip to main content
DAX in Power Pivot

Advanced DAX Functions and Concepts

If you’re working for a global company, you may find your data’s dates need significant transformation in the prep stage. DAX can speed this up with its time intelligence functions, but the process can seem a little daunting at first. In this course, you’ll learn how to implement these and explore some of the important concepts that underpin DAX, such as contexts and filtering.

Advanced        11 Lessons        150 Minutes        CPD Credits
Start Today

About This Course

If your date fields are stored in tables, with differing formats, DAX can transform these using its time intelligence feature. The functions may be a little more challenging to implement, but with this course, you’ll learn how to execute them methodically.

Across 11 lessons, you’ll learn how to use DAX’s date functions and apply filters throughout to offer insights based on time.

By the end of the course, you’ll have a comprehensive understanding of how to use Power Pivot’s DAX formula to boost your data analysis.

Start Today

Learning Outcomes

  • Use DAX’s date functions
  • Add a date table to a data model
  • Create variables in a data model
  • Use relational functions like RELATED
  • Use filtering functions like FILTER and ALL
  • Understand the row and filter contexts in DAX
  • Understand how context transition works in DAX


1. Using Date Functions
2. Adding and Using Date Tables
3. Time Intelligence Analysis
4. Working with Variables
5. Using Relational Functions
6. Applying the Filter Function

Read More

7. Other Filtering Functions
8. Understanding the Row Context
9. Multiple Row Contexts
10. Understanding Filter Contexts
11. Context Transition in Power Pivot
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