topic Re: append two user created tables in Developer

append two user created tables

KukoyLP — Wed, 27 Jul 2016 14:11:25 GMT

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.

Re: append two user created tables

Eric_Zhang — Fri, 29 Jul 2016 02:02:21 GMT

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

Re: append two user created tables

KukoyLP — Tue, 02 Aug 2016 13:51:20 GMT

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.

Re: append two user created tables

Eric_Zhang — Sun, 07 Aug 2016 23:41:32 GMT

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