Practical use case for Power Query metadata
How to extract the number of records at each filter step in a query.
Thanks to these 2 resources:
🧑🏻💻Chandeep:
• Reference an Intermediate Step from a...
🧑🏻💻Abhay Gadiya
• Referencing Intermediate steps from o...
🔢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...
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/