How to filter Min & Max Value (Power Query - Excel & Power BI) @ExcelExciting
How to filter Min & Max Value (Power Query - Excel & Power BI)  @ExcelExciting
Uploaded January 2021 | Updated November 2026, 3 days ago
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
excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/42487501-power-query-number-filter-option-to-have-maximum-o
--------------------------------------------------------------
๐ŸŒŽ Download the file here
excelexciting.com/how-to-filter-max-or-min-value-in-power-query-for-excel-power-bi
--------------------------------------------------------------
๐Ÿ›’ Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: 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.
--------------------------------------------------------------
๐ŸŒŽ ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
๐Ÿ‘๐ŸปLike Facebook Page:
facebook.com/ExcelExciting

๐Ÿ‘ฅJoin the Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well

Extract Multiple Matching Records
youtu.be/pTVxxaZQx24

Learn how to use Microsoft Flow / Power Automate
youtu.be/HQyxnPYW9Jc

NON-VBA Solution Convert Number to Words in Microsoft Word [mac & windows]
youtu.be/W1Ghyp6Rla0

Excel with 41Million+ Records & still why UK has Data Loss of COVID-19 Cases?
youtu.be/YVMTgZsRCGQ

***********************************************************
#Excel #PowerBI #PowerQuery #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForWindows #ExcelTricks
How to filter Min & Max Value (Power Query - Excel & Power BI)Extract Number & Text from a Cell in Excel | Solution 02 by Power QueryTwo Best Excel Tricks by Excel Experts (Andreas & Faraz)The Power of 7 Visuals- Exploring Diagrams with Nurana NovruzovaThe lesser known parts of Excel with David StavegรฅrdExcel & Power Automate (Work Best Together) with Faraz ShaikhHow to Install & Setup WhatsApp on Apple Macbook M1 ProExcel Tips & Tricks with Bob UmlasType for you as you speak - New Feature of Office365 | mac & windowsExcel Trick# 20 - Stop dragging! Fill numbers automatically #shorts #excel #excelexciting #microsExcel Trick# 28 โ€“ Highlight Top 3 Values in Excel #shorts #excel #excelexciting #microsoftexcelLearn Exactly How to Get Crude Oil, Natural Gas & Other Commodities Prices in Excel
Faraz Shaikh |

How to filter Min & Max Value (Power Query - Excel & Power BI)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER