In this video, we dive into everything you need to know about building custom functions in Power Query. Learn how to use the each _ and (x, y) syntax, define optional parameters, and most importantly, how to share your custom functions across multiple files for better reusability and efficiency. Perfect for
anyone looking to level up their Power Query skills!
00:00 Introduction
00:35 each _
03:00 General definition
04:35 Argument type
05:20 Optional Argument07:40 Sharing betwen files