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 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. 

 

 

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

2 Replies

  • 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