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 logicalDescription
Returns true if value value1 is equal to value value2, false otherwise.
Related articles
Learn more about Value.Equals in the following articles:
- Power Query Precision: Avoid Rounding Errors
Learn how to handle precision differences in Power Query. With these tips you can return accurate numbers and prevent rounding errors. » Read more
Related functions
Other functions related to Value.Equals are:
