Forum Discussion

LotteLaugesen's avatar
LotteLaugesen
Icon for Helper V rankHelper V
3 years ago
Solved

Create new table based on calendar and products

Hi 

I have a calendar dimension and a product dimension and need to combine these to a new table with all dates for all products like this: 
Calendar 

Products 

Result 

Is that possible in Power Query?
BR

Lotte

 

 

Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi LotteLaugesen ,

     

    Add a new custom column in your Calendar table with the formula ' = Products '.

    This will create a Cartesian Product of the Calendar and Products tables.

     

    Pete

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    3 years ago

    Hi LotteLaugesen ,

     

    Add a new custom column in your Calendar table with the formula ' = Products '.

    This will create a Cartesian Product of the Calendar and Products tables.

     

    Pete