Comparer.Equals

The function returns a true or false value by checking if the two given values, x and y, are equal according to the provided comparer. A comparer is a tool used to customize how the comparison is done. Comparers can be used to make comparisons ignore the case of letters or take into account the culture and locale settings. In the formula language, the following built-in comparers are available: - Comparer.Ordinal: It compares the values exactly in their original order. - Comparer.OrdinalIgnoreCase: It compares the values exactly while ignoring the case of letters. - Comparer.FromCulture: It compares the values taking into account the cultural context of the comparison.

To determine if the values of "1" and "A" are equal, use the "en-US" locale for comparison. This can be done using the MComparer.Equals function in Power Query: MComparer.Equals(Comparer.FromCulture("en-US"), "1", "A") The output of this comparison will be false.