The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a data model with multiple sources. These sources all have the same field names. I'm needing to create a new table that merges certain columns of interest into one. Here is a simplified example of what I mean:
Table1
color | height | weight |
blue | 6 ft | 125 lbs |
green | 1 ft | 600 lbs |
Table2
color | height | weight |
yellow | 5 ft | 200 lbs |
purple | 12 ft | 4 lbs |
Table3
color | height | weight |
orange | 7 ft | 3 lbs |
black | 8 ft | 12 lbs |
New_Table
color | weight |
blue | 125 lbs |
green | 600 lbs |
yellow | 200 lbs |
purple | 4 lbs |
orange | 3 lbs |
black | 12 lbs |
I've tried using Merge Queries in Power Query Editor, but as far as I can tell this only merges two tables. What I need is to be able to extract columns from multiple tables to show in a combined new table. Is this possible?
Solved! Go to Solution.
You need to be using Append Queries. You can combine multiple tables and it should give you exactly what you want!
You need to be using Append Queries. You can combine multiple tables and it should give you exactly what you want!