How to merge data

[mng]

Hi, I have a two datasets. I appended 'table 1' and 'table 2' below. I'm trying to merge the location data from table 2 to table 1's rows using UPPER(NTID) and EMPNET_ID as the link to show the location data.

Logic: If there is a match between those two columns, to add the location data to that row. (Sort of a XLOOKUP() you would use in excel.) How could I do that in power bi? 

[mng]

Thank you

[v-stephen-msft]

Hi @mng ,

Glad to help you, please mark my reply as a solution if you can. More people will benefit, thank you.

Best Regards,

Stephen Tao

[v-stephen-msft]

Hi @mng ,

There's a feature you can merge, please refer to

Merge queries overview - Power Query | Microsoft Learn

You can merge as follows.

Expand the tables in the Table 2 column.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.