Uploaded December 2022 | Updated November 2026, 6 days ago
Join us at this Excel Meetup to hear from Mike Thomas from United Kingdom ๐ฌ๐ง about Cube Functions - Where the Worksheet Meets the Data Model
We hear a lot about the benefits of storing your data in Excel's Data Model instead of the worksheet cells. Larger capacity, better performance and the ability to create Pivot Tables from multiple data sources.
But dive a little deeper and you'll find a whole magical world of DAX, Measures and CUBE functions which will help you to take your reporting and data analysis skills to the next level
This session will include...
An overview of the benefits of using The Data Model to store your data
How to create simple Measures using DAX
How to use Excel's family of CUBE functions to pull aggregated values (Sum, Count etc) from the Data Model to the Worksheet
Using CUBE functions to create dynamic Slicers and drop downs
---------------------------
About the Speaker
---------------------------
In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a diverse range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
--------------------------------
Connect with Speaker
--------------------------------
Website : theexceltrainer.co.uk
LinkedIn : linkedin.com/in/thomasmik
YouTube : theexceltrainer.co.uk/youtube
Twitter : twitter.com/thomasmike
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time)."
Join us at this Excel Meetup to hear from Mike Thomas from United Kingdom ๐ฌ๐ง about Cube Functions - Where the Worksheet Meets the Data Model
We hear a lot about the benefits of storing your data in Excel's Data Model instead of the worksheet cells. Larger capacity, better performance and the ability to create Pivot Tables from multiple data sources.
But dive a little deeper and you'll find a whole magical world of DAX, Measures and CUBE functions which will help you to take your reporting and data analysis skills to the next level
This session will include...
An overview of the benefits of using The Data Model to store your data
How to create simple Measures using DAX
How to use Excel's family of CUBE functions to pull aggregated values (Sum, Count etc) from the Data Model to the Worksheet
Using CUBE functions to create dynamic Slicers and drop downs
---------------------------
About the Speaker
---------------------------
In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a diverse range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
--------------------------------
Connect with Speaker
--------------------------------
Website : theexceltrainer.co.uk
LinkedIn : linkedin.com/in/thomasmik
YouTube : theexceltrainer.co.uk/youtube
Twitter : twitter.com/thomasmike
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time)."

![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/304921-excel-for-windows-desktop-application/suggestions/42487501-power-query-number-filter-option-to-have-maximum-o
๐ Download the file here
https://excelexciting.com/how-to-filter-max-or-min-value-in-power-query-for-excel-power-bi
๐ 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 & Power Platform 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
Extract Multiple Matching Records
https://youtu.be/pTVxxaZQx24
Learn how to use Microsoft Flow / Power Automate
https://youtu.be/HQyxnPYW9Jc
NON-VBA Solution Convert Number to Words in Microsoft Word [mac & windows]
https://youtu.be/W1Ghyp6Rla0
Excel with 41Million+ Records & still why UK has Data Loss of COVID-19 Cases?
https://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)](https://i.ytimg.com/vi/icqkXRzKe98/mqdefault.jpg)








