create new table with with additional columns from another table in dax

[MAAbdullah47]

Dear All ,

I have 2 tables with 90 % same structure (same no of rows):

Table -1 : col-1,col2,col3

Table-2 : col1,col2,col3,col4

I want to:

1-Add col4 with the same content from Table-2 to table-1.

2-Copy the contents of col2 (Table-2) and Paste it in col2 for Table-1

After that, I 'll remove Table-2, Please advise.  

[v-yuezhe-msft · Accepted solution]

@MAAbdullah47,

You can perform the following steps in Query Editor.

1. Add a index column for Table-1 and Table-2.

2.Merge Table-1 and Table-2 by clicking “Merge Queries as New”.

3. Expand col2 and col4 from the column as below in the merged table.

4. Select “col2” and “Index”, then remove the two columns.

5. Rename Table-2.col2 and Table-2.col4.


Regards,

[Greg_Deckler]

May be easier to do this in Power Query. What are the sources of the tables? For example, in Power Query, you should be able to do a Merge query between the two queries you have. Are these tables comprised purely of columns imported from sources or are some of these columns calculated?

Otherwise, you might look at NATURALINNERJOIN, INTERSECT, UNION or other similar types of DAX functions.

[MAAbdullah47]

Kindly can you give me by example ?