PRODUCT

The PRODUCT function multiplies multiple values together and returns the resulting value. It performs multiplication across all provided numbers or node references and is commonly used in calculations involving totals, scaling factors, or combined values.

Syntax

PRODUCT(value1, value2, ... valueN)

Arguments

  • value1, value2, ... valueN: Numbers or node references to multiply.

Return value

Returns the product of the specified values.

Example

PRODUCT(Unit Price, Units)

In this example, the Total Sales measure is created using the PRODUCT function, which returns the product of the values in Unit Price and Units.

Excel equivalent

PRODUCT


Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.