Forum Discussion
Random Number
How can I use RANBETWEEN formula, but make it more stable, as everytime i open the report , it varies too much.
Eg: I am using RANDBETWEEN(90,210) but the variation should be minimum each time i open the report/refresh.
Hi Anonymous
Thank you very much dharmendars007 for your prompt reply.
The generation of random numbers focuses on randomness, so you want the RANDBETWEEN function to be more stable, which may defeat the meaning of randomness.
However, you might consider pre-generating a table of random numbers and using it in your report so that the random numbers are within the range of the pre-generated table on every refresh. For example:
"RandomNumbers"
Create a measure.
RandomNumber = VAR Index = RANDBETWEEN(1, COUNTROWS('RandomNumbers')) RETURN CALCULATE( FIRSTNONBLANK('RandomNumbers'[RandomValue], 1), FILTER('RandomNumbers', 'RandomNumbers'[Index] = Index) )Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous
Thank you very much dharmendars007 for your prompt reply.
The generation of random numbers focuses on randomness, so you want the RANDBETWEEN function to be more stable, which may defeat the meaning of randomness.
However, you might consider pre-generating a table of random numbers and using it in your report so that the random numbers are within the range of the pre-generated table on every refresh. For example:
"RandomNumbers"
Create a measure.
RandomNumber = VAR Index = RANDBETWEEN(1, COUNTROWS('RandomNumbers')) RETURN CALCULATE( FIRSTNONBLANK('RandomNumbers'[RandomValue], 1), FILTER('RandomNumbers', 'RandomNumbers'[Index] = Index) )Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous ,
When you say resut should be minimum can you be more specific like coould you share a example like expected result..This will help us to check further.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!
Thank You
Dharmendar S
