Table.PositionOfAny - Power Query

Search…

published

ItemExpression.From

RowExpression.Column

RowExpression.From

Table.AddColumn

Table.AddIndexColumn

Table.AddJoinColumn

Table.AggregateTableColumn

Table.AlternateRows

Table.ColumnCount

Table.ColumnNames

Table.ColumnsOfType

Table.CombineColumns

Table.ContainsAll

Table.ContainsAny

Table.DemoteHeaders

Table.DuplicateColumn

Table.ExpandListColumn

Table.ExpandRecordColumn

Table.ExpandTableColumn

Table.FilterWithDataTable

Table.FirstValue

Table.FromColumns

Table.FromPartitions

Table.FromRecords

Table.FromValue

Table.FuzzyJoin

Table.FuzzyNestedJoin

Table.HasColumns

Table.InsertRows

Table.IsDistinct

Table.MatchesAllRows

Table.MatchesAnyRows

Table.NestedJoin

Table.Partition

Table.PositionOf

Table.PositionOfAny

Table.PrefixColumns

Table.PromoteHeaders

Table.RemoveColumns

Table.RemoveFirstN

Table.RemoveLastN

Table.RemoveMatchingRows

Table.RemoveRows

Table.RemoveRowsWithErrors

Table.RenameColumns

Table.ReorderColumns

Table.ReplaceErrorValues

Table.ReplaceKeys

Table.ReplaceMatchingRows

Table.ReplaceRelationshipIdentity

Table.ReplaceRows

Table.ReplaceValue

Table.ReverseRows

Table.SelectColumns

Table.SelectRows

Table.SelectRowsWithErrors

Table.SingleRow

Table.SplitColumn

Table.ToColumns

Table.ToRecords

Table.TransformColumnNames

Table.TransformColumns

Table.TransformColumnTypes

Table.TransformRows

Table.Transpose

Table.UnpivotOtherColumns

Table.ViewFunction

Tables.GetRelationships

Powered By GitBook

Table.PositionOfAny

Table.PositionOfAny
Returns the position or positions of any of the specified rows within the table.
function (table as table, rows as list, optional occurrence as nullable any, optional equationCriteria as nullable any) as nullable 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.     
Category
Table.Membership
Examples
Find the position of the first occurrence of [a = 2, b = 4] or [a = 6, b = 8] in the table ({[a = 2, b = 4], [a = 6, b = 8], [a = 2, b = 4], [a = 1, b = 4]}).
1
Table.PositionOfAny(Table.FromRecords({[a = 2, b = 4], [a = 1, b = 4], [a = 2, b = 4], [a = 1, b = 4]}), {[a = 2, b = 4], [a = 6, b = 8]})
Copied!
0
Find the position of all the occurrences of [a = 2, b = 4] or [a = 6, b = 8] in the table ({[a = 2, b = 4], [a = 6, b = 8], [a = 2, b = 4], [a = 1, b = 4]}.
1
Table.PositionOfAny(Table.FromRecords({[a = 2, b = 4], [a = 6, b = 8], [a = 2, b = 4], [a = 1, b = 4]}), {[a = 2, b = 4], [a = 6, b = 8]}, Occurrence.All)
Copied!
{0, 1, 2}

Table.PositionOf

Table.PrefixColumns

Last modified 3yr ago

Copy link

Contents

Table.PositionOfAny