Power Query Custom Functions - Easily Create Your Own Custom Functions in 3 Easy Steps
HTML-код
- Опубликовано: 27 июл 2024
- 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...
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
🚀🔥
Great video. Like the way you have selected a small dataset, just large enough to demonstrate the principle. Thank you.
a brilliant explanation of Custom Function. I would honestly suggest that a learner of Power Query must watch this video for learning Custom Function.👌👍
Thank you so much for your support Zahoor! 😀
Thank you for this helpful video.👋
Amazing video... Learned about power query. Good work!
Thank you Premjit :)
Very useful! Thank you!
Glad to hear Florin :)
Learnt a lot here, thank you!
Glad it was helpful!
Sensacional...muito obrigado!!! Parabéns pelo trabalho!!!
You’re most welcome! I’m glad the video was helpful 😊
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.
Thank you so much dravetch for your kind words and for the suggestion! I've added it to my plans for the channel, thanks!
Dear Miss M.,
super, great. Your explanation is great and I can follow, even I am not an PQ expert.
I’m glad to hear Norbert!
Absolutely brilliant video !! Thank you so much.
You're most welcome! Glad it was helpful :)
Very helpful, learned some great tricks in this video
Glad it was helpful J!
Great explanation, you’re a very good teacher!
Thank you!
@barttrudeau9237 thank you for the coffees! You made my day ☕️☕️☕️
Very nicely explained and presented.
Thank you!
Great video n PQ! Do more like this videos with Custom Fx, or reusable Fx and so on =)
Thank you! Stay tuned there will be more :)
Thank you!👍🤛💯
You're most welcome!
Thank you. Subscribed.
Awesome, thank you Thamil!
Dear Miss M.,
great, super and thanks.
You're welcome Norbet :)
Amazing tips thanks so much
You're so welcome!
Excellent Thanks 🌹🌹👍👍
Thank you Kebin :)
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.
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
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.
Because your data will get import to power query by converting in to tables so y she is using as table
Good tips
Thank you, glad it was helpful!
Superb 👌 video Miss
Thank you!
@@MissMicrosoft you’re always welcome 🤗
@@MissMicrosoft but I need to tell you thank you for giving such a wonderful content 😌 In power query
It’s my pleasure! Just glad it’s helpful 😊
@@MissMicrosoft that so nice 😊
👋 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
I will do my best :)
@@MissMicrosoft thanks a lot
@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: ruclips.net/video/kqHMP0OzzBo/видео.html
ruclips.net/video/eSbHsZQhmE0/видео.html
ruclips.net/video/K_N2Rj6wVfE/видео.html
ruclips.net/video/cgjsJkMm8ME/видео.html
@@MissMicrosoft thanks a lot 🙏
The background music is annoying and distracting.
Hi David, I’ve removed the music from my subsequent videos, please check and let me know if this is better: ruclips.net/video/Dwet7lMBvos/видео.htmlsi=XafWjYlzhfjKWvD2
on point, Thank you so much
You are so welcome 🙌