Combining Unrelated Columns

[CoopyJoe]

I have two unrelated tables that I would like to combine and make a larger key list. Is there a way to achieve the result on the very right? I am using a DirectQuery connection, and would simply like to join these two customer/vendor key lsits with one another. Thanks for the help.

[CoopyJoe]

Thanks so much, Greg. This got me the result I wanted!

[Greg_Deckler · Accepted solution]

@CoopyJoe Hmm, maybe try renaming the columns and then a Table.Combine in Power Query Editor. In DAX you could do the same thing using UNION and SELECTCOLUMNS like:

New DAX Table =
  VAR __Table1 = SELECTCOLUMNS('Table 1', "Customer/Vendor#", [Vendor #], "Customer/Vendor Name", [Vendor Name])
  VAR __Table2 = SELECTCOLUMNS('Table 2', "Customer/Vendor#", [Customer #], "Customer/Vendor Name", [Customer Name])
  VAR __Result = UNION(__Table1, __Table2)
RETURN
  __Result