How to paste a managers email across columns

Question

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 Answer

Hi,
Try this calculated column formula
=lookupvalue(Data[Employee email],Data[Employee manager],Data[Employee Name])
Hope this helps.

Forum Discussion

How to paste a managers email across columns

2 Replies

Related content

Manage Connections

credential management best practices?

Manage Alerts

RLS managed ‚Deanonymization‘

Manage visuals outside Pbix