Number.Random

Updated on

Number.Random is a Power Query M function that generates a random number between 0 and 1. The function returns the generated random number.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Number.Random() as number

Description

Returns a random number between 0 and 1.

Examples

Get a random number.

// Output: 0.919303
Number.Random()

Learn more about Number.Random in the following articles:

Other functions related to Number.Random are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/number-random