Lookup value in M Code

[jcastr02]

I have two queries as per below.  I am trying to do an M code to pull over Employee Title into query B using Employee ID as the unique identifier.  I would need this to be done in M code vs. DAX, please.  Thanks so much. 

Employee ID	Employee Title					Employee ID	Employee Name	Employee Title
12345	Lead					12345	Joy, Ann	?
67890	Lead					67890	Smith, Joey	?
111111	Technician					111111	Kain, Lisa	?
444444	Technician					444444	Coy, Junior	?
666666	Lead					666666	King, Jaqueline	?
Query A					Query B

[ImkeF · Accepted solution]

Hi @jcastr02 ,

you can use the Merge operation in Power Query to do this:
Merge queries (Power Query) - Excel (microsoft.com)