Take Control with Custom Comparer Functions in Power Query | Rick de Groot

**Please note the earlier than usual start time due to the time zone difference with our presenter.

SESSION TRACK:
Excel & Power BI

SESSION OUTLINE:
In this session, we will explore custom comparer functions in Power Query. While Power Query offers standard functions for comparing values, such as Comparer.Ordinal and Comparer.OrdinalIgnoreCase, you can gain more control by creating your own comparison logic. This means your operations can become much more tailored to your needs. We'll look at how to use these custom comparer functions for grouping and sorting values.

SPEAKER PROFILE:
Rick de Groot is a Power BI consultant, blogger, YouTuber, and author from the Netherlands. With a background in finance, he has devoted 14+ years to building his expertise in data analysis, particularly in the Power Query M language. He is an independent consultant who also provides training on Power BI, Power Query, and DAX. He regularly publishes articles on his blogs, Power Query How and BI Gorilla, which have emerged as important sources for M language articles and tutorials. He contributes extensively to his YouTube channel BI Gorilla as well. Rick’s sharing has earned him the Microsoft Data Platform MVP award for two consecutive years.

Connect with and follow Rick online at:

• Website: gorilla.bi
• YouTube: youtube.com/bigorilla
• Blog: powerquery.how
• LinkedIn: https://www.linkedin.com/in/rickmaurinus/

TENTATIVE AGENDA (subject to change, all times listed are in Pacific Time):

• 9:45am Teams Meeting opens to attendees to begin joining
• 10:00am-10:05am Welcome and meeting overview
• 10:05am-11:05am Feature Presentation
• 11:05am-11:10am Meeting Wrap-up

REGISTRATION:
This meet-up will be hosted on Microsoft Teams, 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 Teams Meeting link.

JOINING THE EVENT:
Attendees can join the Teams Meeting starting at 9:45am on the day of the event. The link will be visible only if you RSVP beforehand.

Once the event gets underway at 10:00am, we ask that attendees make sure they are on MUTE, so background noise and distractions are minimized.

During the presentation, attendees can type questions and comments into the chat area, which will be monitored by the event hosts. There will be time for Q&A at the end, where attendees can un-mute their mic and even share their video to ask questions.

**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.

A link to the recording will be posted here on the event page and on the Excelguru social media channels once it is available (usually a day or 2 after the event).