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
| Function | Description | Input | Output |
|---|---|---|---|
| Comparer.Equals | Returns a logical value based on the equality check over the two given values. | Function | Logical |
| Comparer.FromCulture | Returns a comparer function given the culture and a logical value for case sensitivity for the comparison. | Text | Function |
| Comparer.Ordinal | Returns a comparer function which uses Ordinal rules to compare values. | Any | Number |
| Comparer.OrdinalIgnoreCase | Returns a case-insensitive comparer function which uses Ordinal rules to compare values. | Any | Number |
