Project Botticelli

Status message

See the new version of this article on Tecflix.com! Why? Read our announcement.

Hierarchies in DAX Purchase this course

25 November 2017 · 152 views

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.