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

Anonymous's avatar
Anonymous
Not applicable
9 years ago
@smoupre wrote:

Number.Random

 

or

 

Number.RandomBetween:

Hi, thanks for your reply but I was looking for solutions for text values.

tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago
Same as we create sample data in excel, u just create one master table with 2 Column(id,text) and in fact table you add one column as reference column by random in range of id column of table master. After that make the relationship between 2 table.