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 ,
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.