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