RAND

The RAND function returns a random decimal number between 0 and 1. A new random value is generated each time the function is evaluated or the report is refreshed. This function is commonly used in simulations, sample data generation, testing scenarios, and calculations that require random values

Syntax

RAND()

Return value

Returns a random decimal number greater than or equal to 0 and less than 1.

Example

RAND()

In the example below, the Rand measure is created using the RAND function, which generates a random decimal number between 0 and 1 each time the report is evaluated or refreshed.

Excel equivalent

RAND

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.