Lookup value in M Code

Question

I have two queries as per below.&nbsp; I am trying to do an M code to pull over Employee Title into query B using Employee ID as the unique identifier.&nbsp; I would need this to be done in M code vs. DAX, please.&nbsp; Thanks so much.&nbsp;&nbsp;Employee IDEmployee Title&nbsp;&nbsp;&nbsp;&nbsp;Employee IDEmployee NameEmployee Title12345Lead&nbsp;&nbsp;&nbsp;&nbsp;12345Joy, Ann?67890Lead&nbsp;&nbsp;&nbsp;&nbsp;67890Smith, Joey?111111Technician&nbsp;&nbsp;&nbsp;&nbsp;111111Kain, Lisa?444444Technician&nbsp;&nbsp;&nbsp;&nbsp;444444Coy, Junior?666666Lead&nbsp;&nbsp;&nbsp;&nbsp;666666King, Jaqueline?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Query A&nbsp;&nbsp;&nbsp;&nbsp;Query B&nbsp;&nbsp;

imkef · Accepted Answer

Hi&nbsp;jcastr02&nbsp;,
you can use the Merge operation in Power Query to do this:Merge queries (Power Query) - Excel (microsoft.com)
&nbsp;

Forum Discussion

Lookup value in M Code

1 Reply

Related content

Lookup rank value?

Lookup help

Lookup value

lookup value in another column

M Code help LOOKUP

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