EXP DAX Function (Math and Trig)

Syntax  |  Return values  |  Remarks  |  Examples  |  Related  

Returns e raised to the power of a given number.

Syntax

EXP ( <Number> )

Parameter	Attributes	Description
Number		The exponent that is applied to the base e.

Return values

Scalar A single decimal value.

Returns e raised to the power of a given number. The constant e is the base of the natural logarithm and is approximately 2.71828182845904.

Remarks

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

EXP(1) returns the approximate value of e.

To calculate powers of bases other than e, use the exponentiation operator (^) or the equivalent POWER function.

» 3 related functions

Examples

--  Logarithmic functions include LOG10, LN, LOG, and EXP to compute
--  logarithms using various bases or exponential.
DEFINE
    VAR Vals = GENERATESERIES ( 1, 25, 4 )
EVALUATE
ADDCOLUMNS ( 
    Vals,
    "LN",       LN      ( [Value] ),
    "LOG10",    LOG10   ( [Value] ),
    "LOG 5",    LOG     ( [Value], 5 ),
    "EXP",      EXP     ( [Value] )
)

Value	LN	LOG10	LOG 5	EXP
1	0.00	0.00	0.00	2.72
5	1.61	0.70	1.00	148.41
9	2.20	0.95	1.37	8,103.08
13	2.56	1.11	1.59	442,413.39
17	2.83	1.23	1.76	24,154,952.75
21	3.04	1.32	1.89	1,318,815,734.48
25	3.22	1.40	2.00	72,004,899,337.39

Related functions

Other related functions are:

• LN
• LOG
• LOG10

Last update: Sep 28, 2022   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber,

Microsoft documentation: https://docs.microsoft.com/en-us/dax/exp-function-dax