Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PATH function with CALCULATE

Hi,   I have a hierarchy table with column "ID" and "Parent ID". In the same table, I have this hierarchy for each week, so depending the week, the "Parent ID" may changes.   ID Parent ID We...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

 

PATH(<ID_columnName>, <parent_columnName>)

 

<ID_columnName> contains the unique identifier of the row in the table. The ID column cannot have duplicate values.

 

 

Path = PATH([ID],[Parent ID])

 

 

Reference: PATH function(DAX)

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.