PATHCONTAINS

Syntax

PATHCONTAINS(<path>, <item>)

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:

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



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.