Forum Discussion

ClemFandango's avatar
ClemFandango
Icon for Advocate II rankAdvocate II
3 years ago
Solved

How to join query based on two columns using Power Query

Hi there, PowerBI people! I have a query called “Market” that is merging a query (called “Sheet2”) using a left outer join. The code being used is shown below = Table.NestedJoin(#"Reordered Columns...
Need Help
Show and Tell
  • HotChilli's avatar
    HotChilli
    3 years ago

    You put the columns in the same section as the existing join key {  "field1", "field2"}.

    If you use the interface to select the key columns, you select the first 2 columns then use 'shift' key and select more pairs of columns

ClemFandango's avatar
ClemFandango
Icon for Advocate II rankAdvocate II
3 years ago

Thanks HotChilli!