Value.NullableEquals
Compares two values as Value.Equals does, but answers null when either of them is null.
Group: Values, types and errors. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Value.NullableEquals(value1 as any, value2 as any, optional precision as nullable number) as nullable logical| Parameter | Type | Description |
|---|---|---|
value1 | any | The first value. |
value2 | any | The second value. |
precision | nullable number optional | Precision.Double (the default) or Precision.Decimal. |
Returns
nullable logical. true or false, as Value.Equals would say; null when either value is null.
Remarks
- It is the comparison for data where null means unknown: an unknown value is neither equal nor unequal to anything.
- Only a null on its own counts: a list or record with a null inside is compared item by item, as
Value.Equalscompares it.
Examples
Two shops of the same name
Value.NullableEquals("Oslo", "Oslo")trueNext to Value.Equals
{Value.Equals(null, null), Value.NullableEquals(null, null)}{true, null}Value.Equals takes two nulls as equal; this one says it can't tell.
Order lines checked against a target of 1
List.Transform({1, null, 3}, each Value.NullableEquals(_, 1)){true, null, false}