Looking up values from another table using a unique key M query

Hey darrylwjk ,

using the Merge operation is the way to go, after the Merge you have to expand the table (the employee) table, if you keep the username then you can compare the values that have been used for the join.

You have to be aware that PowerQuery/M is capital sensitive, this is not the case for SSAS Tabular/DAX
For this reason I recommend that you transform the username in the employee table into all capital letters using the UPPERCASE transformation:

Hopefully, this provides what you are looking for.

Regards and Merry Christmas,

Tom

Hi TomMartens ,

Oh I see let me try these steps you have adviced thanks! It could be because I didn't convert the username to uppercase that's why the mapping values returned got messed up ...