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: 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: ✅ 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: 🎦 Power Query in Excel Beginners Tutorial: Combine Multiple Excel Sheets, Automate & Transform Data: 🎦 Power Query Age Analysis - Create an Excel Age Analysis Report Using Power Query: 🎦 Power Query Error Handling - How to Deal with Power Query Errors Part 1: ✅ Please also check out my Excel course on Udemy, please use this link: 📖