Forum Discussion
Solved
PATH Partition by
Is there any way to build a path that is to be partitioned by an additional partition column (group by column)
desired result - partitioned by Q
| Q | parent | child | rowNum | path |
| - |...
For a data like this, a path can be simply built out by doing this
and other path callbacks work perfectly on that "built-out path". I did think it would be so simple. Not sure, if this is going to create any issues later, but for now I am working with this.
To use multi parent hierarchies you need to disambiguate/clone the children. Child 20 needs to be split into 20.1 and 20.2
cf. Parent-Child Hierarchies with multiple parents in Power BI with Power Query (thebiccountant.com)
I am not looking for a power query solution, as long as, each parent-child pair has a corresponding partition by column as it is in my case, a simple dax concatenation of parent, child with '|' would create the path, where all the related path callbacks apply