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
Sounds like you are talking "M" Power Query language. If that is the case, you could use:
Number.Random
https://msdn.microsoft.com/en-us/library/mt253346.aspx
or
Number.RandomBetween:
https://msdn.microsoft.com/en-us/library/mt253327.aspx
If you want to do it in DAX, the only thing I can think of would be Sample:
https://msdn.microsoft.com/en-us/library/mt163692.aspx
@smoupre wrote:Number.Random
or
Number.RandomBetween:
Hi, thanks for your reply but I was looking for solutions for text values.