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.
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.