Forum Discussion

Frequent Visitor

2 years ago

Solved

How to expand parent-child in Power Query/M

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 recur...

Need Help

zubair242
2 years ago
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

mussaenda

Community Champion

2 years ago

Hi zubair242 ,

Recursive Code.pbix27 KB

zubair242
Frequent Visitor
2 years ago
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

Forum Discussion

How to expand parent-child in Power Query/M

Related content

Parent/child hierarchy creation

Power Query - flatten Parent-child hierarchy

Parent pipeline invokes old version of child pipeline until parent is re-saved

Dax measure parent/child

Parent/Child Hierarchies visual with multiple parents