Mastering DAX Workshop
DAX does not have any built-in functions that provide calculations over hierarchies between attributes and entities. However, the underlying data model can include the definition of hierarchies used by client tools to simplify the browsing experience over data. A data model supports only regular hierarchies between columns of the same table, and does not have a native support for parent-child hierarchies.
In this section, you will learn how to create calculations over hierarchies and how to use DAX to transform a parent-child hierarchy into a regular hierarchy managed by the data model, hiding levels that should not be visible in a ragged hierarchy.
After a recap of parent-child hierarchies, you should start working on Lab 8.
Log in or purchase access below to the premium version of this content.
Querying with DAX
Mastering DAX Workshop (Current)
1.
Introduction to DAX 1-hour 1-minFree
2.
Table Functions 32-min
3.
Evaluation Contexts 42-min
4.
CALCULATE Function 32-min
5.
Evaluation Contexts and Relationships 1-hour 8-min
6.
Building a Date Table 19-min
7.
Working with Iterators 36-min
8.
Time Intelligence in DAX 56-min
9.
Querying with DAX 1-hour 9-min
10.
Hierarchies in DAX 28-min
11.
Advanced Relationships 1-hour 14-min
12.
Lab Exercise Files and Presentation PDF
Purchase A Full Access Subscription
- Payment is instant and you will receive a tax invoice straight away.
- Your satisfaction is paramount: we offer a no-quibble refund guarantee.
Jump to a chapter
- Introduction to Hierarchies (00:08)
- Parent-Child Hierarchies (04:25)
- Hiding Levels in Parent-Child Hierarchies (15:52)
- Parent-Child Hierarchies Recap (24:16)
- Lab 8 (27:09)