PATHCONTAINS function


Advertisements

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

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements