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

     

     

Stachu's avatar
Stachu
Community Champion
7 years ago

add a new column and type 

= Product

(where Product is the name of your product table), then expand the columns

pcowman1's avatar
pcowman1
Helper I
6 years ago

Just learned a fabulous new to me thing from this! LOVE IT!