cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pkoel-asb
Helper IV
Helper IV

New User Power Query full outer join

Hello All,

 

  I am using Power BI Desktop. I select the option to Transform my data and I am brought into Power BI's Power Query editor. I have two files that have no relationship between them. I want to join the two files togather using a full outer join. When I try to use the Merge Queries, it forcese me to slect a column to join the table upon. There is no common column between them. All I want is every record in File 1 joined to every record in File 2. Something similar to the following:\

Select *

from File1

FULL OUTER JOIN(File2);

 

How do I accomplish htat?

 

Cheers!

 

Peter

1 ACCEPTED SOLUTION
HotChilli
Super User II
Super User II

I think you want a cross-join.

There are at least a couple of ways to do it. One is :

Add a column to the first table like this

= table2

 

You can then expand the column.  Give me a shout if that's not what's required.

View solution in original post

3 REPLIES 3
HotChilli
Super User II
Super User II

I think you want a cross-join.

There are at least a couple of ways to do it. One is :

Add a column to the first table like this

= table2

 

You can then expand the column.  Give me a shout if that's not what's required.

View solution in original post

I found it! I figured out what you were trying to tell me. YES, it works well! thank you!

Hello,

 

  Thank you for your reply. I can not find a Cross-join function in Power BI, but does sound like the task I need to complete. How do I cross join two tables into one?

 

Cheers,

 

Peter

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors