Creating an employee manager relationship table

Hi, dollarvora 

Try steps as below:

1. Create a calculated table:

Table = UNION(DISTINCT('Original table'[Employee Name]),DISTINCT('Original table'[Manager Lvl1]),DISTINCT('Original table'[Manager Lvl2]))

2.create  a index column in new table

Index = RANKX('Table','Table'[Employee Name],,ASC,Dense)

3.create  calculated columns "Manage Name" ,"Manage ID" ,"PATH" :

Manager Name =
VAR column_lv1 =
    LOOKUPVALUE (
        'Original table'[Manager Lvl1],
        'Original table'[Employee Name], 'Table'[Employee Name]
    )
VAR column_lv2 =
    LOOKUPVALUE (
        'Original table'[Manager Lvl2],
        'Original table'[Manager Lvl1], 'Table'[Employee Name]
    )
RETURN
    IF ( ISBLANK ( column_lv1 ), column_lv2, column_lv1 )

Manage ID = LOOKUPVALUE('Table'[Index],'Table'[Employee Name],'Table'[Manager Name])

Path = PATH('Table'[Index],'Table'[Manage ID])

The result will show as below:

 

For more details,please check the attached pbix file.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.