List.Numbers
This function generates a list of numbers starting from a given initial value and for a specified count. An optional parameter can also be provided to determine the increment value. By default, the in...
This function generates a list of numbers starting from a given initial value and for a specified count. An optional parameter can also be provided to determine the increment value. By default, the increment value is set to 1.
Parameters:
- start: The initial value of the list.
- count: The total number of values to be generated.
- increment: [Optional] The value by which each subsequent number in the list is increased. If not specified, each value is incremented by 1.
Example 1
Create a sequence of 10 numbers in a row, starting from 1.
Instructions:
Utilize Power Query MList.Numbers(1, 10)
Result:
{1, 2, 3, 4, 5, 6, 7, 8, 9, 10}
Example 2
Generate a list of 10 numbers starting at 1, with each subsequent number increasing by 2.
Instructions:
Utilize Power Query MList.Numbers(1, 10, 2)
Result:
{1, 3, 5, 7, 9, 11, 13, 15, 17, 19}