Comparer functions

 

The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.

FunctionDescription
Comparer.EqualsReturns a logical value based on the equality check over the two given values.
Comparer.FromCultureReturns a comparer function given the culture and a logical value for case sensitivity for the comparison. The default value for ignoreCase is false. The value for culture are well known text representations of locales used in the .NET framework.
Comparer.OrdinalReturns a comparer function which uses Ordinal rules to compare values.
Comparer.OrdinalIgnoreCaseReturns a case-insensitive comparer function which uses Ordinal rules to compare the provided values x and y.
Culture.CurrentReturns the current culture of the system.
Show: