DAX Function Guide

RANDBETWEEN
Empty image or helper icon

Sam McKay

CEO & Founder

How does the RANDBETWEEN work?
The RANDBETWEEN function (DAX) returns a random number in the range between two numbers you specify.
RANDBETWEEN Formula Syntax

RANDBETWEEN(
     <bottom>,<top>
)

How do you use the RANDBETWEEN?

Use the RANDBETWEEN function to get a random integer between bottom and top. For example, =RANDBETWEEN(1,50) might generate the number 28

Related Blog Posts

Loading

Considerations when using the RANDBETWEEN?

The RANDBETWEEN function syntax has the following arguments:

Bottom(Required).-The smallest integer RANDBETWEEN will return.
Top(Required)-The largest integer RANDBETWEEN will return.

Related Video Tutorials

Loading

Formula examples using the RANDBETWEEN

=RANDBETWEEN(1,10)

=RANDBETWEEN(-1,1)

=RANDBETWEEN(1,50)

Related Courses

Loading