Duplicating date for each distinct value

[ZKailar]

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!

[AlB · Accepted solution]

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]

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!