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?
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.
