Forum Discussion
Solved
create new table with with additional columns from another table in dax
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 Ta...
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,
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,