Forum Discussion
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...
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
Given your list of words, here's a method that creates another list that contains 1 million items randomly selected from the initial list:
let
list = {"Apples", "Bananas", "Pears"},
shuffle = List.Generate(
() => 1,
each _ <= 1000000,
each _ + 1,
each list{Number.RoundDown(
Number.RandomBetween(0, List.Count(list))
)}
)
in
shuffle