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

Related Support Forum Posts

Exponential explosion of rows running Power Query
Measure not give the same result inside SWITCH
Translating INR amount to USD based on user slicer selection

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.

Formula examples using the EXPfunction

=EXP(0) // returns 1

=EXP(1) // returns 2.71828182846 (the value of e)

=EXP(2) // returns 7.38905609893

Related Course Modules 