Forum Discussion
Create new table from multiple tables...
Ok. I want to create a new table or view from multiple tables/columns. Can Power BI do that? Thanks
Refer this:https://radacad.com/append-vs-merge-in-power-bi-and-power-query
There are other functions like union, selectcolumns , summarize that can do it in Dax.
amitchandak
Super User
Super UserRefer this:https://radacad.com/append-vs-merge-in-power-bi-and-power-query
There are other functions like union, selectcolumns , summarize that can do it in Dax.
JustSayJoe
Advocate IV
Advocate IVThat link talks about joining tables & merging queries. What about when we don't want to join entire tables together? Rather, create a brand new table taking only specific columns from multiple existing tables.