Forum Discussion

ZKailar's avatar
ZKailar
Frequent Visitor
7 years ago
Solved

Duplicating date for each distinct value

Hi All!

 Im looking for a way to create a new table that duplicates the date for each distinct value in another table/column. I currently have a date table and another table that is pulling the distinct values. This is what it should look like:

DATE         Color

1/1/2019   Blue

1/1/2019   Green

1/1/2019   Black

1/2/2019   Blue

1/2/2019   Green

1/2/2019   Black

1/3/2019   Blue

1/3/2019   Green

1/3/2019   Black

 

 Thanks in advance for any help!

  • Hi ZKailar 

    You should show the original tables or explain better how the new table is built. It is not completely clear. Try creating a calculated table like this:

    NewTable =
    CROSSJOIN ( 'Date'[Date], OtherTable[Color] )

     

     

     

2 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion

    Hi ZKailar 

    You should show the original tables or explain better how the new table is built. It is not completely clear. Try creating a calculated table like this:

    NewTable =
    CROSSJOIN ( 'Date'[Date], OtherTable[Color] )

     

     

     

    • ZKailar's avatar
      ZKailar
      Frequent Visitor

      That worked well, i have a couple things to change but that will work! Thanks for the help, and ill keep that in mind for future posts. Thanks again!