PATH: Returns a string that contains a delimited list of IDs, starting with the top/root of a hierarchy.
https://dax.guide/path/
PATHCONTAINS: Returns TRUE if the specified Item exists within the specified Path.
https://dax.guide/pathcontains/
PATHITEM: Returns the nth item in the delimited list produced by the Path function.
https://dax.guide/pathitem/
PATHITEMREVERSE: Returns the nth item in the delimited list produced by the Path function, counting backwards from the last item in the path.
https://dax.guide/pathitemreverse/
PATHLENGTH: Returns returns the number of items in a particular path string. This function returns 1 for the path generated for an ID at the top/root of a hierarchy.
https://dax.guide/pathlength/
This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.
How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: https://www.sqlbi.com/books/thedefin...
Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt
#dax #powerbi #ssas #tabular #analysisservices #powerpivot