Forum Discussion

Dicken's avatar
Dicken
Post Prodigy
2 months ago
Solved

Non volatile random numbers between

Hi,  is there a way to create a stablel random list bwtween, two numbers;     so a staable list  1 to 10  could be  = List.Transform( List.Random( 20,1), (x)=> Number.IntegerDivide( ( x * ...
Need Help
Show and Tell
  • ibarrau's avatar
    ibarrau
    2 months ago

    You are missing the +min at the end to make it start from 97. If you run yours, the numbers won't start from min. Check the one I have shared for ten values (Count):

    If this is not what you are looking for, please describe the ouput you are imaging for the function.

    Regards

ibarrau's avatar
ibarrau
Super User
2 months ago

You are missing the +min at the end to make it start from 97. If you run yours, the numbers won't start from min. Check the one I have shared for ten values (Count):

If this is not what you are looking for, please describe the ouput you are imaging for the function.

Regards

Dicken's avatar
Dicken
Post Prodigy
2 months ago

Thanks, think i've got it; 
let
acount = 20,
max = 20 ,
min = 10 ,
range = (max - min) +1 ,
rnd =
List.Transform(
List.Random( acount , 1 ),
each Number.IntegerDivide(_ * range, 1) + min
)
in
rnd

Just trying to get the logic, i see it and then it slips away  😊