Forum Discussion

matthewtian777's avatar
matthewtian777
Frequent Visitor
6 years ago
Solved

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 th...
Need Help
  • JosefPrakljacic's avatar
    JosefPrakljacic
    6 years ago

    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's avatar
JosefPrakljacic
Solution Sage
6 years ago

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

  • matthewtian777's avatar
    matthewtian777
    Frequent Visitor
    6 years ago

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