Forum Discussion
Creating new table using existing
Hi, I am trying to create new table using existing tables as shown in the example below TABLE_A TABLE_B TABLE_C TABLE_D 1-A 1-B 1-C 1-D 2-A 2-B 2-C 2-D 3-A 3-B 3-C ...
Anonymous , Create a copy of this table in power Query.
In the existing table drop column table_B , Table_D
and new Table table drop column table_A , Table_C
append these two tables
Duplicate table -https://radacad.com/reference-vs-duplicate-in-power-bi-power-query-back-to-basics
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
amitchandak Thank you for your respond.
but actual tables are containing rows in millions hence processing time with this method is more than accpetable.
Is it possible to do it with DAX in one step or faster?Thanks