Uploaded September 2024 | Updated September 2026, 2 weeks ago

---

How to extract the number of records at each filter step in a query.

Thanks to these 2 resources:
🧑🏻‍💻Chandeep:
youtu.be/weafpG2yG1w?si=oM2s_VaIElTD-7Cu&t=361

🧑🏻‍💻Abhay Gadiya
youtu.be/JkNYvFoJ6HQ?si=tBoxdtc9xHVz955e

🔢Code:
Code also inside the Excel file

let

//MyQuerySteps = [

Your Code

//] in MyQuerySteps[YourLastStep] meta [MetaReference = MyQuerySteps]

in YourLastStep



📂Copy of File
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EiabCrVyIUVMqLfN9OldAroBDa6bzdvzqXjaeRgJ1zlChw?e=9m7dqM


Access Analytic
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/

Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
wyn.bio.link