Managing Hierarchies with multiple Parents

[OELM]

Hello,

I have a table in which I am managaing all the Child-Parent Relationships of all dimensions. However when it comes to one particular dimension, I have a problem and I can't use the PATH function because I have multiple hierarchies within this dimension (meaning that I have for the same Child multiple Parents). To make it easier to understand here is an example:

The cost center VVP3 is in my main hierarchy but it is also part of Marketing Cost centers hierachy and thus having both Marketing & VP2 as a Parent.

Is there any workaround to solve this problem?

Thanks in advance

[lbendlin]

Create duplicates of the affected child nodes so that each of them has a single parent.

Parent-Child Hierarchies with multiple parents in Power BI with Power Query