Power Query
published
Search
⌃K

Comparer.Equals

Comparer.Equals

Returns a logical value based on the equality check over the two given values.
function (comparer as function, optional x as nullable any, optional y as nullable any) as logical

Description

Returns a logical value based on the equality check over the two given values, x and y, using the provided comparer. comparer is a Comparer which is used to control the comparison. Comparers can be used to provide case insensitive or culture and locale aware comparisons. The following built in comparers are available in the formula language:

Category

Comparer

Examples

Compare "1" and "A" using "en-US" locale to determine if the values are equal.
Comparer.Equals(Comparer.FromCulture("en-us"), "1", "A")
false