Forum Discussion
Power Query Cross Join
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
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.