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 dist...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    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] )

     

     

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

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
7 years ago

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!