EXP
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