Need Help? Chat with us
[email protected] +1 203-349-9909 / +91-8080042523

Learn How to Filter Records Using Power Query

Filter records is a feature of Power Query that allows you to filter the data from your data table. Let’s see how to filter the records in Power Query with an example.

Filter Records By Power Query

Step 1: Load Data in Power Query

Sometimes the data table is too huge and you do not want to view or access the entire data table. Therefore, the best way is to filter out data and keep only the desired data.

Load the data in Power Query as shown in the picture below. Go through the table and check what data you want to keep and decide accordingly the conditions to filter out data.

LOAD DATA IN POWER QUERY

Step 2: Filter data using Text Filters

To filter the data using the text filter, go to –

Filter arrow of Name column  >  Text Filters  >  Begins with  >  OK

FILTER TEXT

Step 3: Filter Text by applying different conditions

When you go to the text filter, a Filter Rows Window gets open as shown below. In this case, as we want to apply multiple conditions, we will select the Advanced options for filtering.

Here, we have selected the name staring from letter ‘S’ from the Name column and also selected the HRD from the division column and chosen the OR operator for filtering.

FILTER ROWS WINDOW

Step 4: Close & Apply

As we have chosen OR operator, it will select all the names starting from ‘S’ irrespective of their division and will also select all the divisions having the value‘HRD’irrespective of the names.

The picture below shows the expected result for filtering text. Click on the Close & Apply button to save the changes.

DATA TABLE AFTER FILTERING TEXT

You can learn more :

Leave a Reply