RAND

Generates a random number between 0 and 1 to support simulations and randomized calculations.

The RAND function returns a random decimal number between 0 and 1. It generates a new value each time the function is evaluated and is commonly used in simulations, testing, or scenarios requiring random data.

Syntax

RAND()

Example

In the example below, the Rand measure is created using the RAND function, which generates a random number between 0 and 1.

Applying RAND Function

Excel equivalent

RAND