The 2nd Edition of #25daysofdaxfridays challenge is here!
How can we help?

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

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

Let us know your thoughts...

Table of Contents