List.Range
This function retrieves a portion of the list starting from the specified offset. The function also allows for setting a limit on the number of items in the subset with an optional parameter called of...
This function retrieves a portion of the list starting from the specified offset. The function also allows for setting a limit on the number of items in the subset with an optional parameter called offset.
Determine the subset that begins at position 6 in the sequence of numbers ranging from 1 to 10.
Usage:
Power Query MList.Range({1..10}, 6)
Output:
{7, 8, 9, 10}
Example 2:
Identify the subset of 2 numbers starting at position 6 in the sequence of numbers ranging from 1 to 10.
Usage:
Power Query MList.Range({1..10}, 6, 2)
Output:
{7, 8}