List.Random

This function generates a list of random numbers between 0 and 1 based on the input parameters provided. The "count" parameter determines the number of random values to be generated, while the "seed" parameter (which is optional) is a numeric value used to initialize the random number generator. If the seed parameter is not included, a new set of random numbers will be produced each time the function is called. However, if a specific seed value is provided, the function will generate the same set of random numbers each time it is called with that seed value.

Generate a set of 3 random numbers using Power Query M language. To create the list, use the function List.Random(3). The output will be a list of three random numbers, for example: {0.992332, 0.132334, 0.023592}. If you want to generate a different set of random numbers based on a specific seed value, you can use the function List.Random(3, 2) where 2 is the seed value. The output will be another list of three random numbers, for instance: {0.883002, 0.245344, 0.723212}.