How to extract the number of records at each filter step in a query.
Thanks to these 2 resources:
🧑🏻💻Chandeep:
https://youtu.be/weafpG2yG1w?si=oM2s_VaIElTD-7Cu&t=361
🧑🏻💻Abhay Gadiya
https://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
https://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
https://wyn.bio.link/