List.Positions Function in Power Query

The List.Positions function returns a list of index positions for an input list.

Syntax

List.Positions(list as list) as list

Example:

Power Query M

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

The output of the above code is shown below:

List.Positions function in Power Query
Previous Next