Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Returns TRUE
if the specified item
exists within the specified path
.
PATHCONTAINS(<path>, <item>)
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. |
A value of TRUE
if item
exists in path
; otherwise FALSE
.
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.
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")
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today