Value.Equals

Updated on

Value.Equals is a Power Query M function that checks if value1 is equal to value2. The function returns true if the two input values are equal, false otherwise.

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

Syntax

Value.Equals(
   value1 as any,
   value2 as any,
   optional precision as nullable number,
) as 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 true if value value1 is equal to value value2, false otherwise.

Learn more about Value.Equals in the following articles:

Other functions related to Value.Equals are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/value-equals