PATH, PATHCONTAINS, PATHITEM, PATHITEMREVERSE, PATHLENGTH - DAX Guide

PATH: Returns a string that contains a delimited list of IDs, starting with the top/root of a hierarchy.
dax.guide/path/
PATHCONTAINS: Returns TRUE if the specified Item exists within the specified Path.
dax.guide/pathcontains/
PATHITEM: Returns the nth item in the delimited list produced by the Path function.
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.
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.
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: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...
Code, run, and share DAX with DAX.do: dax.do/?aff=yt

#dax #powerbi #ssas #tabular #analysisservices #powerpivot

[@user-lm5wb8vi1x]

finished WATCHING

[@sandeepbarge4699]

It would really be interesting to see how one can implement RLS on hierarchical tables shown in your example by leveraging these functions. Can you please create one video for the same?

[@Bharath_PBI]

Thank you 👍

[@pbihari0214]

Thank you

[@sandeepbarge4699]

These functions give an error if I have child value having more than 1 parent value. Is there any way to make them work in such a data scenario?

[@SQLBI]

You should create a key for the duplicated node and use that column to create the path. One key could be the path to the node - but of course you cannot obtain it by using the DAX function.