Forum Discussion
Issues Using PATH Function with Multiple Root Nodes in Product Hierarchy
Hi everyone, I'm working with a product hierarchy in Power BI using the PATH function to model parent-child relationships. The challenge I'm facing is that I have multiple root-level products (i.e.,...
Hi Anonymous ,
Thanks for confirming. You're correct, since PATH() requires a strict one-parent-per-child hierarchy, it won’t work for scenarios like yours with many-to-many relationships. Exploring alternatives like bridge tables or custom logic is the right direction.
Thank you.
Hi Anonymous ,
We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.
Thank you.