Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
matthewtian777
Frequent Visitor

How to Merge Two Tables (Vertical Merge)

I want to merge below two tables in Power BI. They have same columns, so I hope to vertically merge below two tables.

I know the best way is to go to "Edit Queries"->"Append Queries". However, as these two tables are generated by DAX from other tables, they cannot be shown in Power Query Editor. So I don't know what to do with this situation. 

 

 Capture3.PNGCapture6.PNG

1 ACCEPTED SOLUTION
JosefPrakljacic
Solution Sage
Solution Sage

Hey @matthewtian777 ,

 

I actually don't understand what you mean by "vertically merge"

 

If you want to use the equivalent of "Append Queries" -> You could use the UNION-TableFunction.

 

If you need to join the tables in DAX you could use

  • NATURALLEFTOUTERJOIN
  • NATURALINNERJOIN
  • ADDCOLUMNS

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

View solution in original post

2 REPLIES 2
JosefPrakljacic
Solution Sage
Solution Sage

Hey @matthewtian777 ,

 

I actually don't understand what you mean by "vertically merge"

 

If you want to use the equivalent of "Append Queries" -> You could use the UNION-TableFunction.

 

If you need to join the tables in DAX you could use

  • NATURALLEFTOUTERJOIN
  • NATURALINNERJOIN
  • ADDCOLUMNS

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

@JosefPrakljacic Thank you, Josef! The UNION function is exactly what I want. 

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.