PATHCONTAINS

Returns TRUE if the specified item exists within the specified path.

Syntax

PATHCONTAINS(<path>, <item>)  

Parameters

Term Definition
path A string created as the result of evaluating a PATH function.
item A text expression to look for in the path result.

Return value

A value of TRUE if item exists in path; otherwise FALSE.

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 function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

The following example creates a calculated column that takes a manager ID and checks a set of employees. If the manager ID is among the list of managers returned by the PATH function, the PATHCONTAINS function returns true; otherwise it returns false.

= PATHCONTAINS(PATH(Employee[EmployeeKey], Employee[ParentEmployeeKey]), "23")