Table.SelectRows

Retrieves a list of rows from the table that meet the specified criteria.

Example 1 Identify and display the rows in the table where the values in the [CustomerID] column exceed 2. Usage To achieve this, utilize Power Query MTable.SelectRows function to filter the rows based on the condition where the value in the [CustomerID] column is greater than 2. Output The resulting table will include only the rows where the [CustomerID] value is 3 or 4, along with their corresponding Name and Phone values. Example 2 Select and display the rows in the table where the names do not contain the letter "B". Usage To accomplish this task, use the Power Query MTable.SelectRows function in conjunction with the Text.Contains function to exclude rows where the Name column contains the letter "B". Output The output table will consist of the rows with names "Jim", "Paul", and "Ringo", along with their respective CustomerID and Phone details.