Forum Discussion
Combining 2 tables without matching rows
Hello, is it possible to combine 2 tables some column match but some aren't match without any matching rows. Just wanted to make this 2 dataset saved as 1 table? Here's the column for my 1st data...
Hi Anonymous ,
Table1:
Table2:
Please try following measure to create a new table to combine two tables:
Table = UNION( SELECTCOLUMNS('Table1',"Column1",'Table1'[Column1],"Column2",'Table1'[Column2]), SELECTCOLUMNS('Table2',"Column1",'Table2'[Column1],"Column2",'Table2'[Column2]) )Is this the result you want?
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
You can create a calaculted column in the table 1 and use LOOKUPVALUE
https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax
to get values from the first column of table 2
Lookupvalue cant get duplicates, im having duplicate on column "employeeName" since the data was entered per month. Is there any other solution? Im getting this error because of duplicate "A table of multiple values was supplied where a single value was expected."