Forum Discussion

Griffin_BI's avatar
Griffin_BI
Frequent Visitor
2 years ago
Solved

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()
)
DATEADD Visit Windows
PARTITION
Rand
  • lbendlin's avatar
    lbendlin
    2 years ago

    yes, as long as your assumption holds true.   The usual disclaimer applies - RAND is not truly random.

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Please explain this part

     

    random numbers that are evenly distributed within each partition of A, B and C

     

    You can only get an "evenly" distributed result with large amounts of data.

  • Griffin_BI's avatar
    Griffin_BI
    Frequent Visitor
    2 years ago

    I'm looking to produce random sample for each partition of A, B and C. I use RAND() to return a random number and then select everything with the random number below a certain value to get a propotion of each partition. This is reliant on the random numbers for each parition being evenly distributed, for example no skew to the upper end or lower ends of RAND(), which produces a number between 0 and 1. Assuming each partition contains many data points, can I use WINDOW and RAND() in the described way to get a evenly distributed set of random numbers for each partition?

    Thank you for responding.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      yes, as long as your assumption holds true.   The usual disclaimer applies - RAND is not truly random.