Power Query Custom Functions - Easily Create Your Own Custom Functions in 3 Easy Steps
Рет қаралды 30,984
Күн бұрын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.
Please click here for the practice file: buymeacoffee.com/missmicrosof...
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:
🎦 Power Query Advanced Editor: • Getting Started with t...
✅ If you would like to connect on LinkedIn:
🤝 www.linkedin.com/in/missmicrosoft
✅ 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:
☕www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe:
🔔 / @missmicrosoft
✅ For more Power Query videos please use the links below:
🎦 Power Query in Excel Beginners Tutorial: Combine Multiple Excel Sheets, Automate & Transform Data: • Excel's Power Query: T...
🎦 Power Query Age Analysis - Create an Excel Age Analysis Report Using Power Query: • Power Query Age Analys...
🎦 Power Query Error Handling - How to Deal with Power Query Errors Part 1: • Power Query Error Hand...
✅ Please also check out my Excel course on Udemy, please use this link:
📖 www.udemy.com/course/excel-fo...
@MissMicrosoft 9 ай бұрын
Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe 🚀🔥
@veebee3969 21 күн бұрын
Great video. Like the way you have selected a small dataset, just large enough to demonstrate the principle. Thank you.
@premjitchowdhury262 2 жыл бұрын
Amazing video... Learned about power query. Good work!
@MissMicrosoft 2 жыл бұрын
Thank you Premjit :)
@zahoorsarbandi2982 Жыл бұрын
a brilliant explanation of Custom Function. I would honestly suggest that a learner of Power Query must watch this video for learning Custom Function.👌👍
@MissMicrosoft Жыл бұрын
Thank you so much for your support Zahoor! 😀
@florincopaci6821 2 жыл бұрын
Very useful! Thank you!
@MissMicrosoft 2 жыл бұрын
Glad to hear Florin :)
@danielmarreiro3167 Жыл бұрын
Sensacional...muito obrigado!!! Parabéns pelo trabalho!!!
@MissMicrosoft Жыл бұрын
You’re most welcome! I’m glad the video was helpful 😊
@parshuramnangare8577 Жыл бұрын
Absolutely brilliant video !! Thank you so much.
@MissMicrosoft Жыл бұрын
You're most welcome! Glad it was helpful :)
@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.
@MissMicrosoft Жыл бұрын
Thank you so much dravetch for your kind words and for the suggestion! I've added it to my plans for the channel, thanks!
@norbertschmidt6532 Жыл бұрын
Dear Miss M., super, great. Your explanation is great and I can follow, even I am not an PQ expert.
@MissMicrosoft Жыл бұрын
I’m glad to hear Norbert!
@ThGrum 4 ай бұрын
Thank you for this helpful video.👋
@louism.4980 2 ай бұрын
Learnt a lot here, thank you!
@MissMicrosoft 2 ай бұрын
Glad it was helpful!
@JDavid-ih9xt Жыл бұрын
Very helpful, learned some great tricks in this video
@MissMicrosoft Жыл бұрын
Glad it was helpful J!
@barttrudeau9237 Жыл бұрын
Great explanation, you’re a very good teacher!
@MissMicrosoft Жыл бұрын
Thank you!
@MissMicrosoft Жыл бұрын
@barttrudeau9237 thank you for the coffees! You made my day ☕️☕️☕️
@Bhavik_Khatri Жыл бұрын
Very nicely explained and presented.
@MissMicrosoft Жыл бұрын
Thank you!
@mirrrvelll5164 Жыл бұрын
Great video n PQ! Do more like this videos with Custom Fx, or reusable Fx and so on =)
@MissMicrosoft Жыл бұрын
Thank you! Stay tuned there will be more :)
@norbertschmidt6532 2 жыл бұрын
Dear Miss M., great, super and thanks.
@MissMicrosoft 2 жыл бұрын
You're welcome Norbet :)
@thamilanban Жыл бұрын
Thank you. Subscribed.
@MissMicrosoft Жыл бұрын
Awesome, thank you Thamil!
@exogyne Жыл бұрын
Thank you!👍🤛💯
@MissMicrosoft Жыл бұрын
You're most welcome!
@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.
@MissMicrosoft Жыл бұрын
I'm so glad to hear that the video is helpful! Please see the practice file, hope it helps: docs.google.com/spreadsheets/d/14VYXhP-3c88Ai9bx6TgEDphc9wohrwSd/edit?usp=share_link&ouid=108573460979392589182&rtpof=true&sd=true
@kebincui 2 жыл бұрын
Excellent Thanks 🌹🌹👍👍
@MissMicrosoft 2 жыл бұрын
Thank you Kebin :)
@joserojas7348 Жыл бұрын
Amazing tips thanks so much
@MissMicrosoft Жыл бұрын
You're so welcome!
@PassionDeLeon 2 жыл бұрын
Good tips
@MissMicrosoft 2 жыл бұрын
Thank you, glad it was helpful!
@veebee3969 15 күн бұрын
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 xxxxxx)? Appreciate your response. Thank You.
@aravindsuresh4147 13 күн бұрын
Because your data will get import to power query by converting in to tables so y she is using as table
@Mahi_paul Ай бұрын
Superb 👌 video Miss
@MissMicrosoft Ай бұрын
Thank you!
@Mahi_paul Ай бұрын
@@MissMicrosoft you’re always welcome 🤗
@Mahi_paul Ай бұрын
@@MissMicrosoft but I need to tell you thank you for giving such a wonderful content 😌 In power query
@MissMicrosoft Ай бұрын
It’s my pleasure! Just glad it’s helpful 😊
@Mahi_paul Ай бұрын
@@MissMicrosoft that so nice 😊
@eslamfahmy87 Жыл бұрын
👋 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
@MissMicrosoft Жыл бұрын
I will do my best :)
@eslamfahmy87 Жыл бұрын
@@MissMicrosoft thanks a lot
@MissMicrosoft Жыл бұрын
@eslamfahmy3541 I've created these videos here that are shorter and focus on one concept at a time, please check them out, hope they help: kzfaq.info/get/bejne/odd4gLNhtODecqM.html kzfaq.info/get/bejne/m7mSe9aLts7RdWQ.html kzfaq.info/get/bejne/gcV-ZbWbm926lnk.html kzfaq.info/get/bejne/mc2apq2cstOcfXk.html
@eslamfahmy87 Жыл бұрын
@@MissMicrosoft thanks a lot 🙏
@davidfamilydoctor9430 9 ай бұрын
The background music is annoying and distracting.
@MissMicrosoft 9 ай бұрын
Hi David, I’ve removed the music from my subsequent videos, please check and let me know if this is better: kzfaq.info/get/bejne/et2Vp5qdsqjan6c.htmlsi=XafWjYlzhfjKWvD2
@s1ngularityxd64 2 жыл бұрын
on point, Thank you so much
@MissMicrosoft 2 жыл бұрын
You are so welcome 🙌
Miss Microsoft
Рет қаралды 27 М.
Scary Teacher 3D Gaming
Рет қаралды 50 МЛН
Excel Off The Grid
Рет қаралды 8 М.
Access Analytic
Рет қаралды 22 М.
Excel Off The Grid
Рет қаралды 20 М.