Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
LotteLaugesen
Helper V
Helper V

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors