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
skourtip
Frequent Visitor

Combine calendar table with list of names

Hi to all

 

I need some help, i have a calendar table and for each day i want to combine with a list of names like this one

Calendar table:

01/01/2022

02/01/2022

03/01/2022

 

Names:

NAME1

NAME2

NAME3

 

The result i want is:

01/01/2022 NAME1

01/01/2022 NAME2

01/01/2022 NAME3

01/02/2022 NAME1

01/02/2022 NAME2

01/02/2022 NAME3

01/03/2022 NAME1

01/03/2022 NAME2

01/03/2022 NAME3

 

Is this possible?

 

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION
bcdobbs
Super User
Super User

You're looking for a cross join or a Cartesian product.

 

If both tables exist in power query you can use this:

https://docs.microsoft.com/en-us/power-query/cross-join

 

or if you need to create a calculated table in dax use:

https://docs.microsoft.com/en-us/dax/crossjoin-function-dax

 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Are both tables available in the Query Editor?  Do you want a Qury Editor solution?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
bcdobbs
Super User
Super User

You're looking for a cross join or a Cartesian product.

 

If both tables exist in power query you can use this:

https://docs.microsoft.com/en-us/power-query/cross-join

 

or if you need to create a calculated table in dax use:

https://docs.microsoft.com/en-us/dax/crossjoin-function-dax

 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

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.