Creating a table with dates and distinct customers

[mfa]

Hello Power Bi Community,

this is my first post so here goes.

I have a table of distinct customers..

Table 1:

Customers

Customer1

Customer2

Customer3

I want to create a table that looks like this

Date        Customer

1/1/21     Customer1

1/1/21     Customer2

1/1/21     Customer3

2/1/21     Customer1

2/1/21     Customer2

2/1/21     Customer3

3/1/21     Customer1

3/1/21     Customer2

3/1/21     Customer3

...

thanks in advance

[Jihwan_Kim · Accepted solution]

Hi, @mfa 

Please check the below.

New Table =

CROSSJOIN(VALUES(Dates[Date]), VALUES(Customers[Customer]))

https://www.dropbox.com/s/rjjpacqj2e1meyf/mfa.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM