Forum Discussion
nick-evans
Advocate I
Advocate IHow to build a tree/hierarchy based on IDs?
I have a site that has a structured hierarchy: Top Space - Child Space - Child Space - Child Space - Items The depth of each space varies, so there can be any random number of subspaces/children...
Because, given your original table Table1, all you would have to do would be
PATH(Table1[SpaceName], Table1[ParentName])
You don't need to use the ID's, it will work perfectly fine with the textual columns as long as they are distinct.
nick-evansAdvocate I
Advocate II have no clue what happened, but after relaunching Power BI Desktop, it does, in fact, work in the way you said it should.
I have exactly what I'm after! Thanks so much :D
erik_tarnvik
Solution Specialist
Solution SpecialistMy pleasure, glad to help!