Number.Random Function of Power Query
The Number.Random function in Power Query returns a random number between 0 and 1.
Syntax
Number.Random() as number
Example: Get a random number between 0 and 1.
Power Query M
let Source = Number.Random() in Source
The output of the above code is:
0.919303