Forum Discussion
Merging two columns from two tabels into one column
I've got 2 columns in 2 different tabels but my data in the table are complementary. As i show you on this screenshot. And i want to merge them to one column, but i doesn't exacly know how to...
Hi Anonymous ,
If your two tables have the same number of columns, consider using the UNION() function.
My test table1:
My test table2:
Please try following DAX:
Table = UNION('Table1','Table2')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.
v-yadongf-msft
Community Support
Community SupportHi Anonymous ,
If your two tables have the same number of columns, consider using the UNION() function.
My test table1:
My test table2:
Please try following DAX:
Table = UNION('Table1','Table2')
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.