This documentation is archived and is not being maintained.

RANDBETWEEN Function (DAX)

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


RANDBETWEEN(<bottom>,<top>)

Term

Definition

Bottom

The smallest integer the function will return.

Top

The largest integer the function will return.

A whole number.

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

=RANDBETWEEN(1,10)
Show: