List.Numbers Function in Power Query
The List.Numbers function returns a list of numbers of specified count of items in the list, starting at initial value and adds an increment. The default increment value is 1.
Syntax
List.Numbers(start as number, count as number, optional increment as nullable number) as list
The following are the parameters of the function:
- start: The initial value in the list.
- count: The number of values to create.
- increment: [Optional] The value to increment by. If omitted values are incremented by 1.
Example: Generate a list of 8 consecutive numbers starting at 1.
Power Query M
let source = List.Numbers(1, 8) in source
The output of the above code is shown below:
Example: Generate a list of 10 numbers starting at 3, with an increment of 5 for each subsequent number.
Power Query M
let source = List.Numbers(3, 10, 5) in source
The output of the above code is shown below:
