Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creating a table with dates and distinct customers

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

  • Hi, Anonymous 

    Please check the below.

     

     

    New Table =
    CROSSJOIN(VALUES(Dates[Date]), VALUES(Customers[Customer]))
     
     
     

    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

1 Reply

  • Hi, Anonymous 

    Please check the below.

     

     

    New Table =
    CROSSJOIN(VALUES(Dates[Date]), VALUES(Customers[Customer]))
     
     
     

    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