List.Skip Function in Power Query

The List.Skip function returns a list after skipping the first count of items of the given list. The count of items to skip is given in the function itself. It is an optional parameter, so if it is omitted, by default first item in the list is omitted.

Syntax

List.Skip(list as list, optional countOrCondition as any) as list

Example: Skip the first item in the given list.

Power Query M

let
  source = {"India", "America", "Canada", "Japan", "Australia", "England"}, 
  return = List.Skip(source)
in
  return

The output of the above code is shown below:

Example: Return a list after skipping the first 2 items of the list.

Power Query M

let
  source = {"India", "America", "Canada", "Japan", "Australia", "England"}, 
  return = List.Skip(source,2)
in
  return

The output of the above code is shown below:

Previous Next