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.
4 Replies
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.
That 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.
Hi Anonymous
Power Query Editor (Edit Queries on the menu) has the ability to join or append tables in a similar way to SQL.
On the home Ribbon, you'll see Merge Queries and Append Queries. Merge will create one row for each matching record of the 2 tables (in simple terms). Append, will but the second table at the bottom of the first, so best to ensure that column names line up first.
Hope that helps.
