Forum Discussion
kosiarz
8 years agoNew Member
how to visualize hierarchical table
Hi,
I have a table that have two important columns 'Id' and 'ParentId'. Is it possible to create a table thath have infinite levels based on this relation? I want to have on top level items with empty 'ParentId' and allow user to drill down for child items. For each row I want to display some aditional properties.
Thx
1 Reply
- Stachu
Community Champion
I think PATH may help, not sure about the 'infinite' levels
https://msdn.microsoft.com/en-us/query-bi/dax/understanding-functions-for-parent-child-hierarchies-in-dax