How to paste a managers email from this table across columns

Question

&nbsp;Hi all, I have a table that looks like this&nbsp;Employee NameEmployee ManagerEmployee EmailManager EmailEmployee 1Manager 1Employee 1&nbsp;@workManager 1&nbsp;@ workManager 2Manager 1Manager2&nbsp;@ workManager 1&nbsp;@ workEmployee 2Manager 2Employee 2&nbsp;@ work&nbsp;Manager 1Manager 3Manager 1&nbsp;@ WorkManager 3@ WorkManager 3Manager 3Manager 3&nbsp;@ WorkManager 3&nbsp;@ Work&nbsp;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, to make sure i have an email column free of blanks. am i able to do this in dax or MQuery?

amitchandak · Accepted Answer

Anonymous , a new column 
maxx(filter(Table, Table[Name] = earlier([Employee Manager]) ) , [Employee email])

Forum Discussion

How to paste a managers email from this table across columns

1 Reply

Related content

Manage Connections

credential management best practices?

Manage Alerts

RLS managed ‚Deanonymization‘

Manage visuals outside Pbix

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
Manager 1	Manager 3	Manager 1 @ Work	Manager 3@ Work
Manager 3	Manager 3	Manager 3 @ Work	Manager 3 @ Work