Microsoft Power Query: Creating Custom Functions with Minimal M

You don't have to be a Power Query genius to get started with custom functions!

Whether you've been with Power Query for a while and are now looking to level up your skills into the world of the Advanced Editor, or you've already started to explore the M language but are trying to clean up your code, custom functions in M can be an extremely powerful tool to have at your disposal. This video will show you what custom functions are for, as well as walk you through how to get started with creating your own custom functions WITHOUT needing any in-depth knowledge of the M language that powers the tool.

With just a few minor changes in the Advanced Editor, you can easily turn applied steps in a query into a function that can be called upon in any query for your model, collapsing complex transformations into a single step.

[joelabacherli]

These are the types of videos that can spark a huge influx of progress. Thank you very much for creating such an easy to understand breakdown of this concept. Code within code, scripts within scripts, it’s a wonderful thing.

[EverythingReimagined]

Custom M Code:

= Table.ExpandTableColumn(
PreviousStep,
"ColumnName",
Table.ColumnNames(Table.Combine(Table.Column(Custom1, "Count")))
)