When we import data into Power Query editor, we should set the scope of data that we need. That means selecting only the rows and columns required for further processing. In the following video, I will show you different ways of keeping the rows that you need with Power Query.
You may download the sample file to follow along.
Cantonese version:
New Generation Finance - Accounting - Controlling using Microsoft BI stack
A Power BI Creator Blog
Work smarter by Mastering Functions in Excel
Your next stop in mastering Power Query and Power BI
Work smarter by Mastering Functions in Excel
Leading Consultants on Power BI and the Microsoft Data Platform
Helping lawyers make the most of Microsoft Excel
Work smarter by Mastering Functions in Excel
Work smarter by Mastering Functions in Excel
Work smarter by Mastering Functions in Excel
Peltier Technical Services - Excel Charts and Programming
Turn your data into opportunity
Q&A about Excel
Doug Glancy's Excel Site
wmfexcel 