How does the EXP function (DAX) work?

The EXP function (DAX) returns e raised to the power of a given number. The constant e equals 2.71828182845904, the base of the natural logarithm.

EXP Formula Syntax

EXP(
<number>
)

How do you use the EXP function?

The EXP function finds the value of the constant e raised to a given number, so you can think of the EXP function as e^(number), where e ≈ 2.718. The exponential function can be used to get the value of e by passing the number 1 as the argument.

Considerations when using the EXP function

To calculate powers of other bases, use the exponentiation operator (^).
EXP is the inverse of LN, the natural logarithm of number.
e stands for Euler’s number.
The number e is a famous irrational number, and one of the most important numbers in mathematics.
The first digits of e are: 2.718281828459…
e is the base of the Natural Logarithms, invented by John Napier. To calculate powers of other bases, use the exponentiation operator (^).
EXP is the inverse of LN, the natural logarithm of number.