Forum Discussion
k_rahul_g
2 years agoFrequent Visitor
Multi level parent child hierarchy summarization
In a hierarchical table "BaseData" , I have to summarise an attribute "timespent" for all LEVELS of child work item. the problem is that the parent (where it need to be summarize) could also be a chi...
ImkeF
2 years agoCommunity Champion
Hi k_rahul_g ,
if you need your table unmodified, you can use this approach:
Parent-Child Hierarchies with multiple parents in Power BI with Power Query (thebiccountant.com)
It works with multiple parents as well.
Please check file enclosed.