Edit

Share via

EXP

  • Article

Applies to: Calculated column Calculated table Measure Visual calculation

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

Syntax

EXP(<number>)

Parameters

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

Return value

A decimal number.

Exceptions

Remarks

  • 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.

Example

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

= EXP([Power])

Related content

Math and Trig functions LN function EXP function LOG function LOG function