Create new table based on calendar and products

[LotteLaugesen]

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

[BA_Pete · Accepted solution]

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

[LotteLaugesen]

@BA_Pete, thank you - exactly what I needed 😊