Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Create column with random values from list

Hi all, I want to define a list a text values, and then create a new column which selects any value from that list. Can anyone please tell me how to select any value from a list? e.g. create a new...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Anonymous 

    Please create a Rank column which display the location of text cell.

    Rank = RANKX(Table1,Table1[Name],,ASC)


    Then, we select any location according the random number between 1 to the max location. Use LOOKUPVALUE function grab the values.

     

    New Column = LOOKUPVALUE(Table1[Name],Table1[Rank],RANDBETWEEN(1,MAX(Table1[Rank])))

    Please refer to the following screenshot.


    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Anonymous 

Please create a Rank column which display the location of text cell.

Rank = RANKX(Table1,Table1[Name],,ASC)


Then, we select any location according the random number between 1 to the max location. Use LOOKUPVALUE function grab the values.

 

New Column = LOOKUPVALUE(Table1[Name],Table1[Rank],RANDBETWEEN(1,MAX(Table1[Rank])))

Please refer to the following screenshot.


Best Regards,
Angelia