Tutorial with example
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:
Watch the tutorial:
Links to the mentioned resources
To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #20
- This function can be used to return a specific level from a hierarchy returned by a PATH function. For example, you could return just the skip-level managers for all employees.
- If you specify a number for position that is less than one (1) or greater than the number of elements in path, the PATHITEM function returns BLANK
- If type is not a valid enumeration element an error is returned.
This DAX function is not supported for use in DirectQuery mode.