How to filter Min & Max Value (Power Query - Excel & Power BI)
In this video we will use a simple trick to filter max or the largest value in Power Query for Excel and Power BI, it not limited to the max value, but you can easily filter min or smallest value in power query. The steps remain the same.
--------------------------------------------------------------
00:00 Introduction
00:20 Understand the problem
01:07 Voting for the idea on Excel User Voice
01:27 Explaining the solution
03:44 Error handling in Power Query
04:13 Max & Min Value
06:00 Testing the solution
06:40 End Screen
--------------------------------------------------------------
🗳 Voting Link
https://excel.uservoice.com/forums/30...
--------------------------------------------------------------
🌎 Download the file here
https://excelexciting.com/how-to-filt...
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: https://amzn.to/3tR4AUN
- Buy Office365: https://bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
https://excelexciting.com/forums/
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
https://www.meetup.com/saudi-arabia-m...
--------------------------------------------------------------
👍🏻Like Facebook Page:
/ excelexciting
👥Join the Facebook Group -
/ excelexciting
***********************************************************
You can check the following videos as well
Extract Multiple Matching Records
• VLOOKUP Multiple Match Rows Records [...
Learn how to use Microsoft Flow / Power Automate
• How to use Power Automate (Microsoft ...
NON-VBA Solution Convert Number to Words in Microsoft Word [mac & windows]
• Convert Number to Words In Microsoft ...
Excel with 41Million+ Records & still why UK has Data Loss of COVID-19 Cases?
• Excel with 41Million+ Records & still...
***********************************************************
#Excel #PowerBI #PowerQuery #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForWindows #ExcelTricks