Hierarchy Table

[JoergSch]

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

[amitchandak · Accepted solution]

@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

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...