How to paste a managers email across columns

[Anonymous]

Hi all, I have a table that looks like this

Employee Name	Employee Manager	Employee Email	Manager Email
Employee 1	Manager 1	Employee 1 @work	Manager 1 @ work
Manager 2	Manager 1	Manager2 @ work	Manager 1 @ work
Employee 2	Manager 2	Employee 2 @ work

Every manager and employee, and their email, will appear in the employee name, and employee email. what i would like to do, is create a calculated column that will search the manager name column, match that name to the employee name, column, and then paste the employee email from that row to be used. am i able to do this in dax or MQuery?

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

=lookupvalue(Data[Employee email],Data[Employee manager],Data[Employee Name])

Hope this helps.

[lbendlin]

You can do that in either Power Query or DAX.  For larger lists likely DAX is faster.

Your sample data is not complete, it is missing the Employee entry for Manager 1. Please correct.