Value.NullableEquals

Value.NullableEquals is a Power Query M function that returns null if either input value is null, otherwise, it is equivalent to Value.Equals. The function returns either null or the result of the Value.Equals function.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Value.NullableEquals(
   value1 as any,
   value2 as any,
   optional precision as nullable number,
) as nullable logical
Argument Attribute Description
value1
value2
precision optional The Precision.Type specifies the accuracy level for calculations. When omitting this argument, Power Query uses Precision.Double by default, which, while efficient, may cause rounding errors with very small fractions. For greater accuracy Precision.Decimal offers a more precise number representation, ideal for tasks requiring high precision.

Description

Returns null if either argument ‘value1‘, ‘value2‘ is null, otherwise equivalent to Value.Equals.

Other functions related to Value.NullableEquals are:

BI Gorilla Youtube Channel

Last update: December 1, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/value-nullableequals
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.