Table.Contains
This function determines if a specific row, or record, is present in the table. Users can choose to include an optional parameter called equationCriteria to specify how the rows should be compared.
This function determines if a specific row, or record, is present in the table. Users can choose to include an optional parameter called equationCriteria to specify how the rows should be compared.
Check if the table has the specified row.
Usage: Power Query M
Table.Contains(
Table.FromRecords([
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"],
[CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
]),
[Name = "Bob"]
)
Output: true
Check if the table has the specified row.
Usage: Power Query M
Table.Contains(
Table.FromRecords([
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"],
[CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
]),
[Name = "Ted"]
)
Output: false
Check if the table has the specified row by comparing only the column [Name].
Usage: Power Query M
Table.Contains(
Table.FromRecords([
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim",