Forum Discussion
Solved
Hierarchy Table
Hello,
I need to build up a hierarchy table visual which shows me a task and its subtasks, whic could have multiple levels.
I have 2 tables.
Table 1 (Tasks):
| ID | Name |
| 1 | Task 1 |
| 2 | Task 2 |
| 3 | Task 3 |
| 4 | Task 4 |
| 5 | Task 5 |
| 6 | Task 6 |
| 7 | Task 7 |
Table 2 (LINKS)
| PARENT | CHILD |
| 1 | 2 |
| 2 | 3 |
| 2 | 4 |
| 5 | 6 |
Task 1 has a child (2), which has 2 childs (3 and 4). Task 5 has a child (6). Task 7 has no child.
Result:
| Task 1 | Task 2 | Task 3 | |
| Task 1 | Task 2 | Task 4 | |
| Task 5 | Task 6 | ||
| Task 7 |
Hopefully someone could help to guide into the right direction.
Many thanks
Joerg
JoergSch , merge table 1 and 2 using ID and Child in Power query
: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Then use path in DAX to get it
example of path
1 Reply
JoergSch , merge table 1 and 2 using ID and Child in Power query
: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Then use path in DAX to get it
example of path