Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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] )
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] )
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!
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |