Find Level of Employee in Organization Hierarchy

[ADSL]

Hi BI Community Team,

I have create a new column in Employee table, and looking for the level 1 & level 2 as the screenshot below.

Any suggestion/advice how can we find it?

Thanks and Regards,

[Ahmedx · Accepted solution]

pls try this

= LOOKUPVALUE(Employee[Employee_Name],Employee[Employee_ID] ,PATHITEM([Path],1,TEXT))
= LOOKUPVALUE(Employee[Employee_Name],Employee[Employee_ID] ,PATHITEM([Path],2,TEXT))

[Ahmedx]

Can you please share  expected output!

[ADSL]

Hi @Ahmedx ,

We're looking for level of employee name: Level 1 --- Sales Manager & Level 2 --- Area Sales Manager as the screenshot below:

Please kindly help.

Thanks and Regards,