Power Query Functions

Introduction

This repository offers a suite of Power Query functions and scripts, aiming to streamline data manipulation tasks. It addresses the lack of a centralized library system in Power Query, helping developers avoid redundant efforts and improve efficiency.

Power Query's absence of shared libraries leads to unnecessary duplication and inefficiencies in development. This project encourages more efficient data handling and reduces development time by aggregating reusable code.

Despite Power Query's limitations, such as its specific M code environment, this initiative promotes community collaboration to expand its capabilities. Through sharing code and expertise, it seeks to overcome inherent challenges and push the boundaries of Power Query's functionality.

This M functions library stands on the shoulders of giants:

This repository was inspired by Injae Park's YouTube video and repository on how to version control M Code, his research and code is a cornerstone of this project; extremely useful were the references he included:

• Imke Feldman's post on expression evaluate came particularly handy when dealing with documentation.
• Kim Burgess' repository, m-tools was instrumental when defining the usage of the functions, the readme file and the idea of "compiling" the functions in a single file to import.

Usage

Library installation and usage

This library is "imported" into Power Query by following these steps:

1. Open the file M.pq and copy the code.
2. Open an advanced editor in Power Query and paste the code; rename the query to "M".
3. Use the functions as records on M. For example, PictureBinary, which is located in the General Folder, has as arguments one table and two numbers, can be invoked like:

M[General.PictureBinary](table, number, number)

Contributing

Contributions are welcome! Feel free to submit a pull request if you have any new functions or improvements to existing ones.

Please contribute in the folder category that best suits. If the folder does not exist, create it.

The functions you create will only work if all the Power Query native functions used are declared in the M.pq file. You can run the M_Creator.py Python script to locate all the functions via regex and rewrite an M.pq file.

Contributing guidelines

1. Make sure to add the corresponding credits to your code. Plagiarism will not be tolerated.
2. Document your functions, for this you can use the file M_FxDocTemplate.pq
3. Comment your code.
4. Have fun! 🎉

Other libraries

Below, you will find other handy PowerQuery libraries that could come in handy:

1. M-tools by Kim Burgess
2. M by Imke Feldmann
3. M Custom Functions by Štěpán Rešl
4. PowerQueryLib by NinMonkey

License

This project is licensed under the MIT License.