RANDBETWEEN Function
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.
Remarks
This DAX function is not supported for use in DirectQuery mode. For more information about limitations in DirectQuery models, see https://go.microsoft.com/fwlink/?LinkId=219172.
Example
The following formula returns a random number between 1 and 10.
=RANDBETWEEN(1,10)