rand
1 Topic
WINDOW and RAND
If I have a table, "Table" with an ID column and three columns, "A", "B" and "C". Will the following produce a table with a new column of random numbers that are evenly distributed within each partition of A, B and C? ADDCOLUMNS( WINDOW(1, ABS, -1, ABS, Table, , , PARTITIONBY(zPreviousMYCases[@A], zPreviousMYCases[@B], zPreviousMYCases[@C])), "@Rand", RAND() )Solved749Views0likes3Comments