TechNet
Export (0) Print
Expand All

RANDBETWEEN Function (DAX)

 

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

Syntax

RANDBETWEEN(<bottom>,<top>)

Parameters

TermDefinition
BottomThe smallest integer the function will return.
TopThe 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 http://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)

Community Additions

Show:
© 2016 Microsoft