Comparer Functions

Comparer functions determine ordering and equality of data. Among others you can use them to compare items case-insensitive, use a particular culture and for example use Ordinal rules.

About BI Gorilla

BI Gorilla is a blog about DAX, Power Query and Power BI. It was founded in 2018 by Rick de Groot with the goal to provide easy to understand resources to help you advance.

Latest Posts

Resolving Dataformat Errors in Power Query M
Convert between Julian and Gregorian Dates in Power Query M
Creating Julian Day Numbers with Power Query M
Mastering Custom Format Strings in Power Query M
Date Formatting in Power Query – Master 18 Custom Formats

M Language Function Reference

You can now find everything you need to know on the Power Query M language (syntax, examples, articles etc.) at https://powerquery.how/.

Newsletter

Free your mind, automate your data cleaning.

Blog Contact Privacy Policy

Comparer Functions

Replace Values in Power Query M (Ultimate Guide)