Forum Discussion
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
- ZKailarFrequent 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!