0 out of 1 rated this helpful - Rate this topic

PATHCONTAINS Function (DAX)

SQL Server 2012

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

PATHCONTAINS(<path>, <item>)

Parameters

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 DAX function is not supported for use in DirectQuery mode. For more information about limitations in DirectQuery models, see http://go.microsoft.com/fwlink/?LinkId=219172.

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")

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD