Welcome to Curbal Learning Portal. Search for answers using the search box below, or create a request for a video or blog if you cannot find your answer.
Popular searches: DAX Glossary | Guided courses | Request a video
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
Reader Interactions