Build a Function That Returns Another Function in Power Query M

Notes

MakeMultiplier(2) returns a ready-made "multiply by 2" function that you can reuse or pass around like any other value.

Requirements

• None - this is a standalone example; adapt the inner logic to your own use case.

How to use this snippet

1. In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Create a Reusable Custom FunctionDefines a query as a function so it can be called with different arguments from other queries.
• Write a Recursive Function with @Defines a function that calls itself using the @ self-reference operator, useful for recursive calculations like factorials.
• Define a Function with Optional ParametersCreates a custom function where some parameters are optional and fall back to a default when omitted.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Build a Function That Returns Another Function.