Create Custom Functions in Power Query


Introduction

Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not robust and not reusable. In order to reuse the same piece of code, you need to create custom functions using Power Query and then use them in the columns.

In this article, I’m going to explain how we can create and use a custom function in Power BI.

Solution

For the sake of this article, I’ll demonstrate how