Number.Random

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()

Related articles

Learn more about Number.Random in the following articles:

• Generating Random Numbers in Power Query
  Generate random numbers, letters, dates, & symbols in Power Query. Find out how to prevent duplicates & generate lists of random values. » Read more

Related functions

Other functions related to Number.Random are:

• Number.RandomBetween

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/number-random
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.