Value.Divide

Value.Divide is a Power Query M function that calculates the result of dividing value1 by value2, with an optional precision parameter. The function returns the division result, using the specified precision if provided.

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

Syntax

Value.Divide(
   value1 as any,
   value2 as any,
   optional precision as nullable number,
) as any

Description

Returns the result of dividing value1 by value2. An optional precision parameter may be specified, by default Precision.Double is used.

Related articles

Learn more about Value.Divide 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.Divide are:

• Value.Add
• Value.Multiply
• Value.Subtract

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