Value.Multiply

Value.Multiply is a Power Query M function that calculates the product of multiplying value1 by value2, with an optional precision parameter. The function returns the product of the two input values, using the specified precision if provided.

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

Syntax

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

Description

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

Related articles

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

• Value.Add
• Value.Divide
• Value.Subtract

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