From the course: Power BI Essential Training

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Reduce data

Reduce data - Power BI Tutorial

From the course: Power BI Essential Training

Start my 1-month free trial Buy for my team

Reduce data

“

- [Instructor] My state pops as a lovely semantic model, but not yet in the shape that I need it to be in so I can use it in Power BI for a state-by-state analysis. So for example, we have this total row at the bottom that I already pointed out. The name is United States, we don't need that. We also have the District of Columbia included. It's not a state. If our intention is only to compare states, then we would need to eliminate the District of Columbia from our dataset. One way to remove both of these rows, District of Columbia and United States total, is to delete any rows that were never admitted to the United States. That means they have a null value in the second column, which is admitted. And while I could select and delete here, remember we don't make any changes here because changes that we make here are not persistent changes. So instead, what we'll want to do is go to Home. And under Queries, select Transform data. Transform data. And this opens the Power Query Editor. And…

Contents