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:

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