Forum Discussion
Relating child line items of same parent
Hi people of powerbi community - i'm fairly new to the power query as a whole and i haven't been able to wrap my head around the below problem: I have a report coming out from a system that shows...
I believe you can achieve this with the following steps:
- merge the query with itself on the combination of Parent process and Item name
- expand "reviewer" of the result table
- hide the line where the original reviewer is the same as the new reviewer
stvsurf
Resolver I
Resolver II believe you can achieve this with the following steps:
- merge the query with itself on the combination of Parent process and Item name
- expand "reviewer" of the result table
- hide the line where the original reviewer is the same as the new reviewer
Thanks! that seems to have worked. Not sure i understand the logic of self-merging the table on itself but the result is as desired. Thanks for the help.