Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Ok. I want to create a new table or view from multiple tables/columns. Can Power BI do that?
Thanks
Solved! Go to 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.
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.
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
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.