RANDBETWEEN

RANDBETWEEN is a DAX function that returns a random number between two specified numbers.

Syntax

RANDBETWEEN(
   Bottom,
   Top
)

Argument	Properties	Description
Bottom		The smallest integer RANDBETWEEN will return.
Top		The largest integer RANDBETWEEN will return.

Return Values

A whole number.

Remarks

This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

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

= RANDBETWEEN(1,10)

Related functions

Other functions related to RANDBETWEEN are:

• RAND

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/randbetween-function-dax