- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
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