Create new table from multiple tables...

[Anonymous]

Ok. I want to create a new table or view from multiple tables/columns. Can Power BI do that?

Thanks

[amitchandak · Accepted solution]

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.

[JustSayJoe]

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.

[Anonymous]

Actually union in combilation with selectcolumns sort of works. I am not seeing all the data I should see. I will look at your link.

Many Thanks

[nhoward]

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.