Table.PositionOfAny

Syntax

Table.PositionOfAny(table as table, rows as list, optional occurrence as nullable number, optional equationCriteria as any) as any

Description

Returns the row(s) position(s) from the table of the first occurrence of the list of rows. Returns -1 if no occurrence is found.

Reference Data

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

Power Query M Functions / Table Functions / Table.PositionOfAny