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