cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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 3
Highlighted
Microsoft
Microsoft

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

 

 

Highlighted

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.

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors