Forum Discussion

KukoyLP's avatar
KukoyLP
Frequent Visitor
10 years ago

append two user created tables

Is it possible to append two user created tables?  When I go to Edit Queries, I don't see my user created tables on the left hand side.  Assuming because the tables weren't created via query, but via Modeling --> New Table.

 

I essentially need to join the data of my two new tables created in Power Bi.

 

Any help would be appreciated.

3 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    10 years ago

    KukoyLP

     

    Yes, the tables created via "New Table" do not appear in "Edit Queries" window.

     

    Are you talking about union or join tables? To union tables, there's a DAX function UNION. While to JOIN tables, there're functions CROSSJOIN,NATURALINNERJOIN,NATURALLEFTOUTERJOIN. However usually you don't have to use them if proper relationship is created among tables.

     

     

    • KukoyLP's avatar
      KukoyLP
      Frequent Visitor
      10 years ago

      I'm talking about Joining tables.

       

      I'm in a situation where I needed to join "New Tables".  I'm using a different approach now though since this seems like a dead end.  Thanks.

      • Eric_Zhang's avatar
        Eric_Zhang
        Microsoft Employee
        10 years ago

        KukoyLP

         

        You can join "New Tables" in DAX with the functions mentioned. What difficulty in joining tables do you have so that you have to say a "dead end"?