Count Rows Using Power Query
Power Query or Get & Transform (From Excel 2016) lets you perform a series of steps to transform your Excel data. One of the steps it allows you to take is to count the number of rows in your query.
And with just one step, you can get the count very easily!
You can also browse our Power Query Tutorial Catalog here.
NOTE 1: You can create random excel workbook online here for practice purposes as I did in this tutorial.
NOTE 2: If You use Microsoft Excel Prior to 2016 Version, then You Need to download Power Query Separately.
Previously In Power Query: How to Split the Date Using Power Query
In excel if you want to count the number of rows of your query then you can use power query or get & transform to complete it within some simple steps.
Here I am going to mention all the steps to follow:
STEP1. Firstly, select your data and press the shortcut Ctrl + T or by going to Insert > Table then it will turn into Excel Table.
STEP2. Now in the second step follow this procedure:
For Office 365 or After 2016: Go to Data > Get & Transform > From Table
For Excel 2013 & 2010: Power Query > Excel Data > From Table
STEP3. Now you have your power query editor then follow this:
Go to Transform> Table > Count Rows