Export (0) Print
Expand All

EXP Function

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns e raised to the power of a given number. The constant e equals 2.71828182845904, the base of the natural logarithm.

EXP(<number>)

Term

Definition

number

The exponent applied to the base e. The constant e equals 2.71828182845904, the base of the natural logarithm.

A decimal number.

EXP is the inverse of LN, which is the natural logarithm of the given number.

To calculate powers of bases other than e, use the exponentiation operator (^). For more information, see DAX Operator Reference for Power Pivot.

The following formula calculates e raised to the power of the number contained in the column, [Power].

=EXP([Power])
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft