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.

Please click here for the practice file: https://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 the Power Query ...  

✅ 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:
☕https://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: The Ultimate Beg...  
🎦 Power Query Age Analysis - Create an Excel Age Analysis Report Using Power Query:    • Power Query Age Analysis - Create an ...  
🎦 Power Query Error Handling - How to Deal with Power Query Errors Part 1:    • Power Query Error Handling - How to D...  

✅ Please also check out my Excel course on Udemy, please use this link:
📖 https://www.udemy.com/course/excel-fo...