Parameters and Custom Functions in Power Query

Parameters and Custom Functions in Power Query in Excel

On Jan 27, 2022, I presented to the Baku Meetup group organized by Ilgar Zarbaliyev. I looked at scenarios where we need to use parameters and custom functions in Power Query. They allow you to make your solution dynamic, easier to maintain while generating the results with less effort.

Comments about this presentation:

“I really enjoyed you Baku meetup presentation. Your explanation and examples of the Custom Functions with Parameters was probably the clearest I have seen. It really helped me get a few things straight in my own mind.”

Mark Proctor, MVP

Learn how to automate your Excel reports
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists
Check other posts about Power Query and Excel in this Blog,

About the Author: Celia Alves

Celia Alves is an awarded Microsoft MVP and Certified Excel Expert, specializing in building highly complex solutions combining VBA, Power Query, and Power Pivot to automate Excel reporting procedures. By combining her experience as an Excel Consultant and two decades as a Mathematics teacher, Celia created a training program to pass on her knowledge and techniques to those who want to stop wasting time in Excel with repetitive and meaningless tasks. Celia is also the founder and leader of the MS Excel meetup group in Toronto, with over 3,000 members worldwide.