How to expand parent-child in Power Query/M

[zubair242]

Hi everyone,

I have got an interesting case where I need to start from the child and find its parents. Futher, I need to check that parent and see if that has another parent. So, it would be a recursive calculation. Below snapshot show the source/required result and my current result. I do not know how to fix the problem.

Can anyone please check that? I have attached the sample pbix for this.

https://drive.google.com/file/d/19B1KqrfUh_hysb6Q6mMGEN4IMgr8ZamS/view?usp=sharing

[mussaenda]

Hi @zubair242 ,

[zubair242 · Accepted solution]

Hi @mussaenda ,

Thank you so much for providing the workaround. Unforutnately, it is a manual workaround. However, I have used chatgpt and found out the dynamic solution without any manual steps. Please find attached file.

Thank you so much for taking time to help me in this issue. It is really appreciated.

https://drive.google.com/file/d/1vXoQS3K2KolROT8WVWNUysKlB5L-RWdK/view?usp=sharing

Kind Regards,

Zubair