Combine calendar table with list of names

[skourtip]

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?

[Ashish_Mathur]

Hi,

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

[bcdobbs · Accepted solution]

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