Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

RANDBETWEEN Function

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.

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)
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.