Combine 2 tables with different number of columns

[Anonymous]

Is it possible to combine 2 different tables where table 1 has 5 columns and table 2 has 7 columns using DAX? 4 columns in each of the table have the same column. It should be like the table has been appended with DAX formula.

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous 

For the Table with lesser columns you can use ADDColumns to addmissing columns as blank().
Then you can use a UNION function to combine the 2 tables

Something like this

CombinedTable = Union(Table1,ADDCOLUMNS(Table2,"MissingColumnName",BLANK()))

[Anonymous]

@Zubair_Muhammad 

Should all the columns in both the tables have the same names?

[Zubair_Muhammad]

@Anonymous 

Union function just requires same number of columns

Columns are combined by position in their respective tables.

Same Names are not necessary

[Anonymous]

@Zubair_Muhammad 

I was able to combine the tables but it took out the blank rows which were required.