Home

Welcome to the User-Defined-Functions wiki!

This repository brings together a set of user-defined functions (UDFs) developed for VBA and Power Query (M Code), with the goal of extending the native capabilities of Excel and Power BI. Here you will find both functions created by me and useful functions developed by others — always properly organized, documented, and referenced.

🎯 Objective

• To centralize, organize, and facilitate access to a catalog of reusable functions
• To accelerate the development of solutions in Excel, Power Query, and Power BI.
• To maintain a versioned and easily searchable repository.
• To reuse functions tested and validated in different contexts.

🤝 Contributions

Any contribution is welcome!

You can contribute by:

• proposing a new interesting function
• improving an existing one
• improving this documentation's repo
• fixing any possible bug function or documentation error
• helping financially through sponsorship

🗂️ Other UDF Repositories

Here is a list of very useful repos of user-defined functions:

• M by Imke Feldmann
• M Custom Functions by Štěpán Rešl
• m-custom-functions by Tirnovar
• M-tools by Kim Burgess
• PowerBi-code by ibarrau
• PowerQueryFunctions by OscarValerock
• PowerQueryLib by NinMonkey