PowerQuery Utilities

A collection of optimized Power Query (M) scripts designed to enhance data transformation, cleaning, and automation in Power BI.

📂 Project Structure

1. fx_CleanText – Advanced name cleaning function for global datasets.
2. fx_CleanEmail - A handy email cleaning & sanitizing function that can be easily extended to your project depending on your situation.

• More Functions Coming Soon...

Getting Started

1. Open Power Query Editor in Power BI.
2. Create a Blank query.
3. Copy the code snippet from (.pq file) into the Power Query Advanced Editor.
4. Apply it in your transformations.
5. A new query gets created as a function.
6. Apply the function in your transformation.

License

This project is open-source under the MIT License.

Contributing

Pull requests are welcome! Feel free to submit new Power Query functions or improvements.

🔗 Resources

• Microsoft Power Query Docs
• Power BI Community

GitHub Cheatsheet

• Git Commands