Power Query Custom Functions - Easily Create Your Own Custom Functions in 3 Easy Steps

A Power Query Custom Function is simply a query that is run by other queries. We’re going to create a custom function using the Advanced Editor. The first step in creating a custom function is to create your main query, then convert that query to a function and third is to invoke that function.

00:00 What is a Custom Function?
00:18 The End Result
00:47 Step 1: Create The Main Query
04:12 How to Rank in Power Query
04:42 How to Use the Group By Function in Power Query
06:30 How to Use Conditional Column in Power Query
07:32 Step 2: Convert Main Query to a Function
10:45 Step 3: How to Invoke a Function in Power Query
16:13 Why Use Custom Functions?

✅ Please see link to video mentioned in this video:

✅ If you would like to connect on LinkedIn:

✅ If you would like to buy me a coffee, so I can get my caffeine in to keep creating as many videos as possible for you :). It's really quick and easy, please use this link:

✅ For more videos please subscribe:

✅ For more Power Query videos please use the links below:

✅ Please also check out my Excel course on Udemy, please use this link:

[veebee]

Great video. Like the way you have selected a small dataset, just large enough to demonstrate the principle. Thank you.

[zahoorsarbandi]

a brilliant explanation of Custom Function. I would honestly suggest that a learner of Power Query must watch this video for learning Custom Function.👌👍

[veebee]

Dear Miss MS, I wanna ask a small question please. @ 8:40 if the source data is a spreadsheet instead of a table what would be the type instead of 'table' i.e. (SalesData as Appreciate your response. Thank You.

[premjitchowdhury]

Amazing video... Learned about power query. Good work!

[davidfamilydoctor]

The background music is annoying and distracting.

[allonewordlowercase]

Hi there, I really liked your video and have subscribed. I have been going down a rabbit hole trying to wrap my head around functions, and this has been one of the more insightful and practical examples. Can I ask that you might make the files available to work on? I really like to be able to follow along to help cement my understanding.

[dravetch]

Love your videos...here's a thought...how about adding a bonus example to select (all?) videos. It would not contain the same exact steps, but related. In this video, you could have a data set that manipulates the data in some other way, like calculating the length of time it takes from the purchase date to the delivery date, for example. Then, give it to your watchers to try on their own, with a solution in a week or two or whatever (a little homework assignment). It would give the user a chance to try what they have learned in a new example. Just an idea. You are doing a great job and providing a wonderful service to the community. Congratulations.

[norbertschmidt]

Dear Miss M.,
super, great. Your explanation is great and I can follow, even I am not an PQ expert.

[mirrrvelll]

Great video n PQ! Do more like this videos with Custom Fx, or reusable Fx and so on =)

[JDavid-ihxt]

Very helpful, learned some great tricks in this video

[parshuramnangare]

Absolutely brilliant video !! Thank you so much.

[danielmarreiro]

Sensacional...muito obrigado!!! Parabéns pelo trabalho!!!

[eslamfahmy]

👋 hi ..actually, good ideas but could you distribute all functions which used into shortage videos
To help me understand easier and explain each function speartly plz

[norbertschmidt]

Dear Miss M.,
great, super and thanks.

[barttrudeau]

Great explanation, you’re a very good teacher!