Forum Discussion
Multi Parent Child Hierarchy
Hi Power BI Community,
I am facing an unique issue. All of you have been very supportive with my requests and i need additional guidance as to how to proceed here.
I have to create a legal entity hierarchy and it is very hard for me to nail down the steps. I have multiple parents and childs for the entities and i have given a sample of the data.
I tried to break down the parent child in different steps but the effort is too much as i have approx 104 unique parents. The problem is that a child is the parent of another child and the list just goes on.
Example -
LE101 is the parent and LE160 is the child. In the next step LE160 is the parent and LE174 is the child. In the next step LE174 is the parent and the list goes on.
Is there a better way i could organize this and come around the mutiple parent child hierarchy. I looked into previous posts and guidance regarding the same but i am unable to proceed further.
Any help here would be highly appreciated.
| Parent LE | Type | Child LE | Type |
| LE101 | 1 | LE000060 | 1 |
| LE101 | 1 | LE160 | 2 |
| LE101 | 1 | LE160 | 3 |
| LE101 | 1 | LE160 | 4 |
| LE101 | 1 | LE170 | 1 |
| LE102 | 1 | LE160 | 3 |
| LE102 | 1 | LE160 | 4 |
| LE102 | 1 | LE160 | 7 |
| LE160 | 1 | LE163 | 1 |
| LE160 | 1 | LE174 | 1 |
| LE160 | 1 | LE185 | 1 |
| LE160 | 1 | LE185 | 2 |
| LE174 | 1 | LE222 | 2 |
2 Replies
- lbendlin
Super User
What have you tried and where are you stuck? This sounds like a job for the PATH functions.
Hi Selvarajen ,
I think you couldn't create hierachy levels only for each Parent.
What kind of result or calculate do you want? Could you share us a sample file without sensitive data and show us a screenshot with the result you want?
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
