My public library of reusable functions, scripts, code snippets, and utilities I have written in PowerQueryM language, adopted in Microsoft Excel (v2016+) and PowerBI; each module is organized into its own folder and includes dedicated documentation.
To provide clarity and consistency across the repository:
- File names: are designed to reflect the function name;
- README files: each folder includes its own README describing parameters, output, and usage examples;
- Code approach:
Depending on the complexity of the module, each folder may provide one or more implementation styles:
- Single monolithic file: A single, self‑contained file that includes the full logic.
- Modular multi-file: The functions are split across multiple files, each stored in its own file. Individual functions can be used independently or combined, with small edits applied where needed.
- Hybrid: Both monolithic and modular version are provided. This gives you the flexibility to either import a single file or adopt a multi‑file workflow.
- Customization: Regardless of the approach, functions may still require minor adjustments (such as customizing parameters, adapting variables or performing simple copy‑paste integration into your project).
| Folder | Description |
|---|---|
| Time Table | Generating customizable time-based tables between two datetimes, with a configurable step duration. |
| Team User Local Folder | Managing user‑specific local root-path folders on shared or team‑based cloud-synced machines. |
Power Query is a data transformation and preparation engine used to perform extract, transform and load (ETL) operations across a wide range of data sources through an extensive library of built‑in connectors.1
A list of references and tools related to Power Query M development:
| Link | Description |
|---|---|
| Official Site (Microsoft) | Official overview, product information and ecosystem resources. |
| Language Reference (Microsoft) | Official documentation of the M language, including functions, types, and syntax. |
| VS Code Extension (Microsoft) | Official Visual Studio Code extension powered by Microsoft for editing Power Query. |