DAX Function Guide

PATHCONTAINS
Empty image or helper icon

Sam McKay

CEO & Founder

How does the PATHCONTAINS work?
The PATHCONTAINS function (DAX) returns TRUE if the specified item exists within the specified path.
PATHCONTAINS Formula Syntax

PATHCONTAINS(
     <path>, <item>
)

How do you use the PATHCONTAINS?

This function checks to see if a folder contains a specified file (or folder).

Related Blog Posts

Loading

Considerations when using the PATHCONTAINS?

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.

Related Video Tutorials

Loading

Formula examples using the PATHCONTAINS

=PATHCONTAINS(PATH(Employee[EmployeeKey], Employee[ParentEmployeeKey]), “23”)

pathcontains(“~/Dropbox”,”Photos”)

pathcontains(Table1[Who is above him];”Frank”)

Related Courses

Loading