List.RemoveFirstN Function in Power Query
The List.RemoveFirstN function returns the resultant list after removing the specified number of elements from the start of the list. The number of elements removed depends on the optional countOrCondition parameter.
Syntax
List.RemoveFirstN(list as list, optional countOrCondition as any) as list
Example: Remove the first two items from the List.
Power Query M
let
Source = {"India", "America", "Canada", "Japan", "Australia", "England"},
RemoveItemsinList = List.RemoveFirstN(Source, 2)
in
RemoveItemsinList The output will be shown in the following image:
