Forum Discussion
Solved
How to create a supervisor hierarchy table:
Let's say I have a table that looks like this: Staff Name Supervisor Ryan *blank* Martha Ryan Erica Ryan David Martha Samantha Erica Kyle Erica How do I build a...
Hi， BBHouston
You also can try a solution in Dax.
Path = PATH('Dax'[Staff Name],'Dax'[Supervisor])Level1 = PATHITEM('Dax'[Path],1)Level2 = PATHITEM('Dax'[Path],2)Level3 = PATHITEM('Dax'[Path],3)Best Regards,
Community Support Team _ Eason
Hi， BBHouston
You also can try a solution in Dax.
Path = PATH('Dax'[Staff Name],'Dax'[Supervisor])Level1 = PATHITEM('Dax'[Path],1)Level2 = PATHITEM('Dax'[Path],2)Level3 = PATHITEM('Dax'[Path],3)
Best Regards,
Community Support Team _ Eason
v-easonf-msft Thank you!!! This solution ended up being the simplest and working the best for me.