Forum Discussion
iBusinessBI
3 years agoKudo Collector
Power Query - flatten Parent-child hierarchy
I have a parent-child hierarchy table. I don't know in advance how many levels there are. I need help with building a function that would flatten the levels. I found this very helpful post: https:...
- 3 years ago
I've solved it with a help of LivioLanzo solution to this post.
https://community.powerbi.com/t5/Desktop/Parent-Child-Hierarchy-Highest-Parent-using-Power-Query-not-DAX/td-p/519919It's dynamic, not fixed solution.
iBusinessBI
3 years agoKudo Collector
I've solved it with a help of LivioLanzo solution to this post.
https://community.powerbi.com/t5/Desktop/Parent-Child-Hierarchy-Highest-Parent-using-Power-Query-not-DAX/td-p/519919
It's dynamic, not fixed solution.
JonSch_bi
1 year agoNew Member
Hi iBusinessBI , I'm looking for exactly this. Would you be so kind to share your PowerQuery / M-Code?
- iBusinessBI1 year agoKudo Collector
Here you can find the code:
https://community.fabric.microsoft.com/t5/Desktop/Parent-Child-Hierarchy-Highest-Parent-using-Power-Query-not-DAX/td-p/519919