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)