Number.Random

A random number from 0 up to, but not including, 1.

Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.

Syntax

Number.Random() as number

It takes no parameters.

number. A number at least 0 and below 1.

Each call gives another number, and each refresh new ones: nothing is repeated from one run to the next.
Scale it for other ranges: times 100, rounded down, plus 1 gives a whole number from 1 to 100. Number.RandomBetween scales it for you.
For a fixed sequence that a refresh gives again, use List.Random with a seed.

Known difference in OpenBI Studio 0.3.79, found while this page was written and run on its engine:

List.Count(List.Distinct(Table.AddColumn(#table({"Order"}, {{1}, {2}, {3}}), "R", each Number.Random())[R])): Power Query gives 1: in a column added with Table.AddColumn (or changed with Table.TransformColumns), every row gets the same random number, and the model loads it so. A Table.Buffer around the added column's table, or Number.RandomBetween, gives each row its own. OpenBI gives each row its own number: 3.

Number.Random()

0.8065618251888952

Number.RoundDown(Number.Random() * 100) + 1

Last updated 8 November 2026 · OpenBI Studio 0.3.79