append two user created tables

[KukoyLP]

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.

[Eric_Zhang]

@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]

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]

@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"?