Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |