Comparer Functions Overview

Updated on

Delve into Comparer Functions in Power Query M Language, crucial for comparing data when transforming data. This page provides a comprehensive list and descriptions of Comparer Functions available in the M Language.

Comparer Functions

FunctionDescriptionInputOutput
Comparer.EqualsReturns a logical value based on the equality check over the two given values.FunctionLogical
Comparer.FromCultureReturns a comparer function given the culture and a logical value for case sensitivity for the comparison.TextFunction
Comparer.OrdinalReturns a comparer function which uses Ordinal rules to compare values.AnyNumber
Comparer.OrdinalIgnoreCaseReturns a case-insensitive comparer function which uses Ordinal rules to compare values.AnyNumber
BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/comparer-functions