Hands-On Business Intelligence with DAX

The PATH, PATHCONTAINS, and PATHLENGTH functions

Let's start with the PATH function. The syntax of the PATH function is as follows:

PATH ( <ID_ColumnName>, <Parent_ColumnName> )

This function will return all of the IDs that are related to the current row, at various levels. In our employee example, it will return the manager of an employee, along with the managers of those managers and so on until it reaches the top-level manager. The list returned is delimited by a vertical bar.

The first parameter is the name of the column containing the unique identifier for the current row, while the second parameter contains the name of the column containing the unique identifier of the current row's parent. The two columns must be of the same data type, ...