Forum Discussion
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...
I tried using th path function and it gives erros that every workitem (i.e. Parent) should also appear as the child in the table. If you examine my Power Query code you will see that this is taken care of.