Table of contents
TOC
Collapse the table of content
Expand the table of content

RANDBETWEEN Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

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)

© 2018 Microsoft