Forum Discussion
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...
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
I have tried to create a join in Power Query but there is no field to join on.
How can I add a new column with the product table data?
add a new column and type
= Product
(where Product is the name of your product table), then expand the columns
Just learned a fabulous new to me thing from this! LOVE IT!
Stachu,
A simple elegant way to do cross join in M.
Many thanks!
