Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Friend,
I need to create a union table from two different tables, with different column name. Let's say union SalesOrder and PurchOrder number into new table's new column called SOPO.
How can I do it?
Many thanks!
Solved! Go to Solution.
You need to rename the column in the 2nd table @River . You can do it before Append operation, or during the append operation. For example, here is Table1 and Table2
THis code does a Union into the new SPMO column
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMgKTxkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [SalesOrder = _t]),
#"Appended Query" =
Table.Combine(
{
Table.RenameColumns(Source, {{"SalesOrder", "SPMO"}}),
Table.RenameColumns(Table2, {{"PurchaseOrder","SPMO"}})
}
)
in
#"Appended Query"
How to use M code provided in a blank query:
1) In Power Query, select New Source, then Blank Query
2) On the Home ribbon, select "Advanced Editor" button
3) Remove everything you see, then paste the M code I've given you in that box.
4) Press Done
5) See this article if you need help using this M code in your model.
Here is my PBIX file to help you see it work.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou need to rename the column in the 2nd table @River . You can do it before Append operation, or during the append operation. For example, here is Table1 and Table2
THis code does a Union into the new SPMO column
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMgKTxkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [SalesOrder = _t]),
#"Appended Query" =
Table.Combine(
{
Table.RenameColumns(Source, {{"SalesOrder", "SPMO"}}),
Table.RenameColumns(Table2, {{"PurchaseOrder","SPMO"}})
}
)
in
#"Appended Query"
How to use M code provided in a blank query:
1) In Power Query, select New Source, then Blank Query
2) On the Home ribbon, select "Advanced Editor" button
3) Remove everything you see, then paste the M code I've given you in that box.
4) Press Done
5) See this article if you need help using this M code in your model.
Here is my PBIX file to help you see it work.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks a lot! Ed. That's what I am looking for.
Glad to help @River
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingFrom the home tab choose Merge queries as new select the two tables and the columns that join them.
Hi JW,
How do you merge them into same column? It appears to me It's more of join.
Thanks,
River
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
7 | |
6 | |
5 |