Power Query
Search…
List.Random

List.Random

Returns a list of random numbers.
function (count as number, optional seed as nullable any) as list

Description

Returns a list of random numbers between 0 and 1, given the number of values to generate and an optional seed value.

Category

List.Generators

Examples

Create a list of 3 random numbers.
1
List.Random(3)
Copied!
{0.992332, 0.132334, 0.023592}
Create a list of 3 random numbers, specifying seed value.
1
List.Random(3, 2)
Copied!
{0.883002, 0.245344, 0.723212}
Last modified 3yr ago