Forum Discussion
Employee supervisor hierchy
I've attched a screenshot of sample data,where I've supervisor and employee.I want to get the list of employee under a supervisor, the next level of subordinates and so on. For instance 12(supervios...
jaideepnema
Solution Sage
Solution SageHi sowmyar ,
Create a calculated column like this:
Hierarchy Check = CALCULATE(CONCATENATEX('Table','Table'[Employee],"-"),ALLEXCEPT('Table','Table'[Supervisor]))which will give you the desired results:
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
jaideepnema If I have a result column like this how can i make use of it in a matrix visual to show an hierachy?
