TechNet
Export (0) Print
Expand All

RANDBETWEEN Function (DAX)

 

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

RANDBETWEEN(<bottom>,<top>)  

Parameters

TermDefinition
BottomThe smallest integer the function will return.
TopThe largest integer the function will return.

A whole number.

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.

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

=RANDBETWEEN(1,10)  

Math and Trig Functions (DAX)
Statistical Functions (DAX)

Community Additions

Show:
© 2016 Microsoft