Table.Contains Function in Power Query
The Table.Contains function returns a boolean value i.e. true or false, after checking whether the given record appears as a row in the input table. The optional parameter equationCriteria may be specified to control comparison between the rows of the table.
Syntax
Table.Contains(table as table, row as record, optional equationCriteria as any) as logical
Example: Check that the table contains the given specified row.
Power Query M
let
MyTable = Table.FromRecords(
{
[CustomerID = 1, Name = "Ashish", Marks = 568],
[CustomerID = 2, Name = "Katrina", Marks = 855],
[CustomerID = 3, Name = "Alia", Marks = 380],
[CustomerID = 4, Name = "Vicky", Marks = 458],
[CustomerID = 5, Name = "Mohini", Marks = 278],
[CustomerID = 6, Name = "Meenakshi", Marks = 289],
[CustomerID = 7, Name = "Esha", Marks = 875],
[CustomerID = 8, Name = "Anjali", Marks = 380]
}
),
return = Table.Contains(MyTable, [Name = "Alia"])
in
return
The output of the above code is true.