Creating Hierarchy\realtionship from table

[ScholesBI]

Hi,

I have the following data table.

Column 1 shows the project id and column 2 shows the mother. 

How can I extract\create a child - parent relationship from the table which rolls up to project PR130008562 as mother.

Taking into consideration that ther also some sub projects like PR 1300008562.10

Thanks,

Leon

[amitchandak]

@ScholesBI , expected output is not clear, Are you looking for path and path length

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

[ScholesBI · Accepted solution]

Thanks for the link .The expected output should be 3 columns\tables which are linked in the correct hierarchy.