Syntax
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.
Keynotes:
01:51 PATH
06:37 PATHLENGTH
07:31 PATHITEM
08:30 PATHITEMREVERSE
09:56 PATHCONTAINS
Download example file:
Link to demo file here.
Remarks
If item is an integer number it is converted to text and then the function is evaluated. If conversion fails then the function returns an error.
This DAX function is not supported for use in DirectQuery mode.
Let us know your thoughts...