Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
User | Count |
---|---|
97 | |
77 | |
77 | |
47 | |
26 |