Take Control with Custom Comparer Functions in Power Query | Rick de Groot| VanPUG Excel - Jul 2024
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: / bigorilla
Blog: powerquery.how
LinkedIn: / rickmaurinus
Sample Files can be downloaded at: https://1drv.ms/u/s!AuhhLgCXSCKKgY98E...
Also, two links to key portions:
Custom comparer functions in Table.Group https://gorilla.bi/power-query/table-...
The List.Sort function with custom comparers: https://gorilla.bi/power-query/how-li...