Create a column with an email value for someone's supervisor

[Jmcdonough1997]

Hey all, heres what im up against. I have a dataset of professors, thier email, and the name of their dean. all the deans are listed in the employees column, as well as their email. what I am trying to accomplish is listing all of the deans emails in a seperate own column for all professors, and im a bit stuck. ive tried IF(CONTAINS() and LOOKUPVALUE with no success any ideas on how to accomplish this is appreciated!

[v-shex-msft · Accepted solution]

HI @Jmcdonough1997,

According to your description, it sounds related to parent-child hierarchy analysis requirements. If that is the issue the case, you can take a look at following link if it helps:

Parent-child hierarchies – DAX Patterns

If the above doesn't help, please share more detailed information to help us clarify your scenario and test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng