Parent and Child functions

These functions manage data that is presented as parent/child hierarchies. To learn more, see Understanding functions for Parent-Child Hierarchies in DAX.

In this section

Function Description
PATH Returns a delimited text string with the identifiers of all the parents of the current identifier.
PATHCONTAINS Returns TRUE if the specified item exists within the specified path.
PATHITEM Returns the item at the specified position from a string resulting from evaluation of a PATH function.
PATHITEMREVERSE Returns the item at the specified position from a string resulting from evaluation of a PATH function.
PATHLENGTH Returns the number of parents to the specified item in a given PATH result, including self.