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 do it.
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.
10 Replies
v-yadongf-msftCommunity Support
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.
lukiz84Memorable Member
Hi,
-In DAX: Create a new Calculated column:
MergedColumn := IF([Col1]<>BLANK(), [Col1], [Col2])-In PowerQuery: Add a custom column:
Table.AddColumn(tbl, "MergedColumn", each if [Col1] <> null then [Col1] else [Col2])- lukiz84
Do you load them in PowerQuery? Tell us a little more about the structure 🙂
- lukiz84