RANDBETWEEN Function (DAX)
Returns a random number in the range between two numbers you specify.
Syntax
RANDBETWEEN(<bottom>,<top>)
Parameters
Term |
Definition |
---|---|
Bottom |
The smallest integer the function will return. |
Top |
The largest integer the function will return. |
Return Value
A whole number.
Example
The following formula returns a random number between 1 and 10.
=RANDBETWEEN(1,10)