Fabric Plan Community Logo
Sign in

EXP

The EXP function returns the value of the mathematical constant e raised to the power of a specified number. It is commonly used in exponential growth calculations, financial modeling, scientific computations, and scenarios involving continuous compounding or natural logarithms.

Syntax

EXP(value)

Arguments

  • value: The exponent applied to the base e.

Return value

Returns the value of e raised to the specified power.

Example

EXP(Plan_Variance %)

In this example, the EXP function is used to create the Projected Growth Factor measure, which returns the exponential growth factor based on the Plan_Variance % values.

Excel equivalent

EXP

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.