← Back to Number functions

Number.RandomBetween

This function generates a random number within a specified range of values, defined by the bottom and top parameters.

Syntax

Number.RandomBetween(bottom as number, top as number) as number

About

This function generates a random number within a specified range of values, defined by the bottom and top parameters.

Explanation

Generate a random number within the range of 1 to 5 using Power Query function MNumber.RandomBetween(1, 5). The output will be 2.546797.