From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Filtering and removing duplicates

Filtering and removing duplicates

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Filtering and removing duplicates

“

- In the U.S. Census Power BI file, we look at the GEOID to county web query, where we want to focus on the State and County details pertaining to each GEOID. Filtering, we can remove, or keep, rows based on whether or not it meets our set criteria, or conditions. Filtering works similarly to removing rows, but we may find it easier when we're working with ranges, or several conditions. We see the summary level column on the very far left hand side of the table. Ten pertains to the United States, so it's a country level. 40, pertains to Alabama, a state, and 50, pertains to the counties within the state. If we click on the summary level drop down, we see, only click load more, we can see more of the filtering options. We only want to keep 40 and 50. So we want to remove 10, 61, 162, and 170. We can do that by unselecting select all, and select 40 and 50. Now we see we have a reduced size data…

Contents