cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LotteLaugesen
Resolver II
Resolver II

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 

LotteLaugesen_0-1663745956861.png

Products 

LotteLaugesen_1-1663745981882.png

Result 

LotteLaugesen_2-1663746003043.png

Is that possible in Power Query?
BR

Lotte

 

 

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
BA_Pete
Super User
Super User

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




@BA_Pete, thank you - exactly what I needed 😊

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors