Forum Discussion
Solved
Combining Unrelated Columns
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 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
2 Replies
Thanks so much, Greg. This got me the result I wanted!
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
