RANDBETWEEN

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)  

See also

Math and Trig functions (DAX)
Statistical functions (DAX)