Print

Create Hierarchies in DAX

In this video we will go through how to work with hierarchies using the following DAX functions: PATH, PATHLENGTH, PATHITEM, PATHITEMREVERSE, PATHCONTAINS
The example used will be a simplified bill of materials (BOM) but in the Microsoft documentation, there is an excellent example for employees and Managers.

Table of contents:

01:51 PATH
06:37 PATHLENGTH
07:31 PATHITEM
08:30 PATHITEMREVERSE
09:56 PATHCONTAINS

Watch the tutorial:

DAX Fridays! #20: Parent and Child Functions -Hierarchies

Links to the mentioned resources

To get the files:
1. Go to Curbal Download Center > DAX Fridays
2. Get File #20

Was this helpful?

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents