From the course: Excel: Power Query (Get & Transform) (2020)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Sorting and filtering data in Power Query
From the course: Excel: Power Query (Get & Transform) (2020)
Sorting and filtering data in Power Query
- [Instructor] Filtering and sorting in Power Query. Filtering in Power Query is very similar to filtering in Excel. There's a pretty robust interface, but sorting is the tricky part. So let's check this out, we've got all this team data, let's take it into Power Query. Cursor in the data range, Data. From Table/Range. Table does have headers, OK. So here, here's a filter button, and we can see we've got number filters, we can check or uncheck whatever we want. We have our between, greater than, et cetera. And then with this text, we can check or uncheck whatever we want. We can select Begins With, Contains, et cetera. That's all pretty cool, but sorting. Look at the sort section. We can sort ascending or descending, but what if we want to sort by levels? In this case, we want to sort by team and then by last name, and then by first name. How do we do that? We have to sort in order. So let's do it, highlight…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.