Extend list of parents & childs

[IlseV]

Hi, I need help with this.

I have a list of 'parent' items and their 'child' items, but some of these child-items are parents themselves. 

So I would like to extend the original list and work with a kind of 'waterfall' rowing.

This is the original list:

parent	child
1291900032	2901162610
1291900033	1291900032
1291900033	1291013451
1291900033	1604694491
1291900034	1291900033
1291900034	1291500094

And as you can see, some of the 'children' are parents of their own: like 1291900032 and 1291900033.

So I would like to get this in final view:

parent	child	child of child	child of child of child
1291900032	2901162610	0	0
1291900033	1291900032	2901162610	0
1291900033	1291013451	0	0
1291900033	1604694491	0	0
1291900034	1291900033	1291900032	2901162610
1291900034	1291900033	1291013451	0
1291900034	1291900033	1604694491	0
1291900034	1291500094	0	0

[v-chuncz-msft]

@IlseV 

You may take a look at the posts below.

• https://community.powerbi.com/t5/Desktop/Employee-ID-to-Manager-ID-lookup-based-on-filtering-Merge/t...
• https://community.powerbi.com/t5/Desktop/Problem-using-the-PATH-function/td-p/627883