Uploaded August 2024 | Updated September 2026, 2 weeks ago
This Excel Date fix is so simple, MM DD YY converted to DD MM YY in just a few clicks
Check out David Benaim's channel
youtube.com/@learnspreadsheets/videos
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
This Excel Date fix is so simple, MM DD YY converted to DD MM YY in just a few clicks
Check out David Benaim's channel
youtube.com/@learnspreadsheets/videos
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








![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:
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 Ive written a book Power BI for the Excel Analyst?
https://pbi.guide/book/
Connect with me
https://wyn.bio.link/ Practical use case for Power Query metadata](https://i.ytimg.com/vi/IgQ-u9R3j8U/mqdefault.jpg)

