PATHCONTAINS function
Description
Returns TRUE if the specified item exists within the specified path. Otherwise, returns FALSE.
Syntax
PATHCONTAINS (<path>, <item>)
Parameters
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
path A string created as the result of evaluating a PATH function. |
| 2 |
item A text expression to look for in the path result. |
Return Value
TRUE or FALSE.
Remarks
If the 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.
Example
= PATHCONTAINS("OrgEmp0001|OrgEmp0002|OrgEmp0006|OrgEmp0014", "OrgEmp000 7") returns FALSE.
= PATHCONTAINS("OrgEmp0001|OrgEmp0002|OrgEmp0006|OrgEmp0014", "OrgEmp000 6") returns TRUE.
dax_functions_parent_child
Advertisements