Table.ContainsAll
The function determines if all the records listed in the rows are present in the table as rows. Users can also include equationCriteria as an optional parameter to manage row comparisons in the table.
The function determines if all the records listed in the rows are present in the table as rows. Users can also include equationCriteria as an optional parameter to manage row comparisons in the table.
Check if the table has all the rows by comparing only the column [CustomerID].
In Power Query M, utilize the function Table.ContainsAll to determine if a table contains all the specified rows. The function takes two parameters: the table to check and a list of rows to compare against. In the examples provided, the function is used to check if the table contains rows with CustomerID 1 and 2. The result of the function is either true or false, indicating whether all the specified rows are present in the table.