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.
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
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.
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.
You can learn more :
- Learn Steps to Import Web Data
- Learn How to Import Data From XML
- How to Unpivot Data Using Excel Power Query
- Consolidate Multiple Excel Sheets Using Power Query