Power Query Cross Join

Hi,

There's also other several ways to do this. 

Method 1: The easiest way to do a crossjoin is to put the table you want to crossjoin, in a custom column. Just write

= TableName

You can then expand the column to get your result. The downside is that this method is slow. 

Method 2: The faster method, is to add a join column to both tables. You can add a dummy value in this column. For example the number 1. Then join the tables together based on this join column. Delete the join column after cross joining the table. 

More details on both method you can find on my blog at: Understanding Join Types in Power Query - BI Gorilla

Enjoy!

--------------------------------------------------

@ me in replies or I'll lose your thread

Master Power Query M? -> https://powerquery.how

Read in-depth articles? -> BI Gorilla

Youtube Channel: BI Gorilla

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.

To create a crossjoin you can either use: 

- Add a helper column in the two tables you want to cross join, and input the same value. Then perform a merge on these columns. It creates a crossjoin

- Reference the table name directly in a custom column -> this also creates a crossjoin. More details you can find here; 

Create All Unique Combinations From Multiple Columns (gorilla.bi)

--------------------------------------------------

@ me in replies or I'll lose your thread

Master Power Query M? -> https://powerquery.how

Read in-depth articles? -> BI Gorilla

Youtube Channel: BI Gorilla

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.