Forum Discussion
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...
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.
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.
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"?