List.PositionOfAny

Syntax

List.PositionOfAny(list as list, values as list, optional occurrence as nullable number, optional equationCriteria as any) as any

Description

Returns the offset in list list of the first occurrence of a value in a list values. Returns -1 if no occurrence is found. An optional occurrence parameter occurrence can be specified.

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / List Functions / List.PositionOfAny