Value.Multiply

Updated on

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
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 the product of multiplying value1 by value2. An optional precision parameter may be specified, by default Precision.Double is used.

Learn more about Value.Multiply in the following articles:

Other functions related to Value.Multiply are:

BI Gorilla Blog

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