Power Query is a great ETL tool that meets most business user needs with an intuitive user interface.

It introduces the concept of custom functions, which you can use to reuse your code multiple times, making your applied steps clearer and easier to maintain and understand.

We will explore two approaches: editing M from the advanced editor or using the Power Query UI.

By the end of this session, you will fully comprehend when, how, and why you should use custom Power Query functions.