Which DAX function returns a string of all the members in the column hierarchy?

Which DAX function returns a string of all the members in the column hierarchy?

• A. CROSSFILTER()
• B. TREATAS()
• C. PATH()
• D. USERELATIONSHIP()

Answer: (C)

PATH builds a delimited string that represents the full path from the topmost ancestor down through the current member in a parent-child hierarchy. It takes the child column and its parent column and returns a single text value like "Grandparent|Parent|Child," showing every level along the way. This makes PATH the natural choice when you need to see or use the entire hierarchy chain in one string. The other functions handle relationships and filtering rather than constructing a path string: they don’t generate the hierarchical path for a row.

PATH builds a delimited string that represents the full path from the topmost ancestor down through the current member in a parent-child hierarchy. It takes the child column and its parent column and returns a single text value like "Grandparent|Parent|Child," showing every level along the way. This makes PATH the natural choice when you need to see or use the entire hierarchy chain in one string. The other functions handle relationships and filtering rather than constructing a path string: they don’t generate the hierarchical path for a row.