OpenBI Docs Buy

Comparer.Equals

Asks a comparer whether two values are the same: true when it answers 0.

Group: Splitters, combiners, replacers and comparers. Power Query M has it too: a query that uses it is written as in Power BI.

Syntax

Comparer.Equals(comparer as function, x as any, y as any) as logical
ParameterTypeDescription
comparerfunctionA comparer, such as Comparer.OrdinalIgnoreCase.
xanyThe first value.
yanyThe second value.

Returns

logical. true when the comparer finds the values equal.

Examples

Case ignored

Comparer.Equals(Comparer.OrdinalIgnoreCase, "OSLO", "oslo")
true

Case counts

Comparer.Equals(Comparer.Ordinal, "OSLO", "oslo")
false

Comparer.Ordinal, Comparer.OrdinalIgnoreCase, Comparer.FromCulture, Value.Equals.

Last updated · OpenBI Studio 0.3.79