Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power Query Cross Join

I have the following two tables in Power Query (Product and Region)   Product a b   Country Area Town House England Tyne and Wear Sunderland A1 England Tyne and Wear...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Hi Anonymous

    you need to add a new column to the Region table, this column would contain the Product table, and then you'd expand this new column

     

     

Rickmaurinus's avatar
Rickmaurinus
Helper V
3 years ago

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.