RANDBETWEEN Function (DAX)

Returns a random number in the range between two numbers you specify.

RANDBETWEEN(<bottom>,<top>)

Parameters

Term

Definition

Bottom

The smallest integer the function will return.

Top

The largest integer the function will return.

Property Value/Return Value

A number (I8)

Example

The following formula returns a random number between 1 and 10.

=RANDBETWEEN(1,10)

See Also

Other Resources

Math and Trigonometric Functions (DAX)

Statistical Functions (DAX)