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
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










![Learn Exactly How to Get Crude Oil, Natural Gas & Other Commodities Prices in Excel
In this video we will learn an easy technique to extract the oil & gas price in Microsoft Excel, we will use the stock data types to get the commodities price like cotton, sugar, petrol, Brent crude, etc. in Excel. Also, see how to use the stock history function to get the historical oil price in Excel.
00:00 Intro
00:38 Why Crude Oil is not getting extract in Excel
01:20 How to know ticker symbol of a stock in Excel
01:50 Getting the commodities stock prices in Excel
03:14 Extracting the historical stock data in Excel
04:00 End Screen
Commodities link: https://www.msn.com/en-us/money/markets/commodities
๐ 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 youre helping me keep my blog up and running and youre 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 & PowerPlatform Meetup
https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/
๐๐ป Like Facebook Page :
https://www.facebook.com/ExcelExciting/
๐ฅJoin The Facebook Group -
https://www.facebook.com/groups/ExcelExciting/
***********************************************************
You can check the following videos as well
Change Multiple Value using Array Method [Excel for Mac & Windows]
https://youtu.be/c8d3xx8KVl8
Un-Stack Data classic way using Excel Online & Excel Mac | Two Solution
https://youtu.be/UvrxmOrr8AQ
Excel Tip by the Excel Queen ๐ธ๐ป(Faraz & Leila)
https://youtu.be/6CEYKRIlppE
Two Best Excel Tricks by Excel Experts
https://youtu.be/ihVtnUDTCBM
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks Learn Exactly How to Get Crude Oil, Natural Gas & Other Commodities Prices in Excel](https://i.ytimg.com/vi/lLoY1mnZYEw/mqdefault.jpg)