Create a Basic Custom Function in Power Query

Creating a Custom Function in Power Query is actually a simple process. Custom functions enable you to provide create more complex data processing with Power Query and maybe even some interactivity. Before learning all that complex stuff, you'd probably need to understand how the heck can you create a customer function in Power Query. I'm going to provide a very basic example of how it's done. After learning this and getting a taste for the M language (the formula language behind Power Query) it's a start to understanding how to create more sophisticated functions later on. Check out the video to see how it's done.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[fionamehta]

Really easy to follow, excellent presenter, thank you for this example.

[AngelSanchez-igjt]

Doug, this is perfect for automating repetitive tasks. i.e. I typically pull data from SQL, the date is formatted yyyymmdd, and I have to reformat as mm/dd/yyyy. Thank you!

[rachaelhanna]

This is the best explanation of a custom function I have found

[tonytan]

so great! looking forward to advanced one. thx

[williamarthur]

Really good intro as for creating one using M, up to now I've only performed the actions and then changed the code in the editor to make a function, so here I've learnt something new.

[nanipandu]

Explained very clearly.. I just started Working on power queries..this is like a kick starter.. thanks a lot

[angelcalaguas]

Hi Doug,
Can I use a list item using Invoke Custom Function? or do I need to convert the list item to a column first?

[chisasukelover]

I finally understand what this does. And Im excited. Hope it works for my Margin thing Im doing. Even if it doesnt, Im still happy to understand now

[MrKirankissan]

A perfect example to get introduced to Custom Functions. Thank you

[tomekkomar]

Super simple, clear and everything is clear. Really the essence. True. I'm impressed !!!

[SwapperTheFirst]

Excellent stuff, very practical (compared to Brian's), though he is a great explainer too.

[vinodkumarsingh]

This is the best for knowledge of the excellent.

[ypjpyqx]

Hello. Thank you very much for the wonderful video. I have one question. Is there any way to make the query table automatically pull data from a value in a new row?

[duncanwil]

Very good! Let me admit that I forgot to add => at the end of the Let statement and that helped me to waste 15 minutes before I found out!

[jmo]

I have tons of functions, where I can export them for store or to be used or called from other excel book?

[jdmxxx]

A practical foray into a complex task. Nice job. Thanks for your effort.

[stephenphan]

Wonderful lesson, Doug.
How can we do Sales comparision this year vs last year by customer when we have dynamic sales revenue line by line by date. By Pivot in excel we can get tabular sheet by year in columns already but I want to see % growth by customer during the year. Ridiculously every one can do manually by copy into value and just use cell divided by cell!!!
THANKS

[rohinibharti]

So I see this is from 2017, has there been updates to do the same operation faster?

[wongjennifer]

Hi Doug, may i know is there any way to Transpose the Data Based on Non- Repeating Pattern in a Column in Power Query? Because I've tried your way to do it but I realised that my group of data column there are some repeating in 4 rows, some in 5 rows... so i have no choice to use ur way to do it.... please help ....

[badmintonlife]

Good video!
How do I remove dash hyphen left or right of a letter, but not between numbers?
00-CM-00-12
00-C-M00-12
00CM-00-12
After transformation
00CM00-12
Thanks