Forum Discussion
Crate Non volatile random list
Hello,
Is there a way to create a fixed random list of numbers; so example ;
List.Transform( List.Repeat({1} ,20 ) , (x)=>
Number.Round( Number.RandomBetween(1,20 ),0))
that will not change when refreshed, other thant loading to excel copy past values re load? which means I may as well have just done it in excel.
Richard
Hi Dicken ,
If you specify a random seed, the List.Random numbers generated should be the same regardless of refresh.
let me know if I understood the query
2 Replies
Hi Dicken ,
If you specify a random seed, the List.Random numbers generated should be the same regardless of refresh.
let me know if I understood the query
As I understand List.Random generates a list of numbers between 0 and 1 ,
I want say whole numbers between 1 and 100 , or whatever, so in excel randaray;
=RANDARRAY(20,1,1,100,TRUE) , copy, paste values.
Richad.
