EXP
e raised to a power.
Group: Math. Compatible with DAX.
Syntax
EXP ( <number> )| Parameter | Type | Description |
|---|---|---|
number | Number | The power to raise e to. |
Returns
Number. e, about 2.71828, raised to the number.
Remarks
- EXP and
LNundo each other:EXP ( LN ( 5 ) )is 5, up to the last digit. - A blank counts as 0, so
EXP ( BLANK () )is 1. - From about 710 the result no longer fits in a number, and the call is an error. A large negative number gives 0.
- Continuous growth uses it: 1,000 growing continuously at 5 % a year for ten years is
1000 * EXP ( 0.05 * 10 ).
Examples
Powers of e
EVALUATE
ROW (
"e", EXP ( 1 ),
"Of 0", EXP ( 0 ),
"Of -1", EXP ( -1 ),
"Of blank", EXP ( BLANK () )
)| e | Of 0 | Of -1 | Of blank |
|---|---|---|---|
| 2.71828182845905 | 1 | 0.367879441171442 | 1 |
Continuous growth
EVALUATE
ROW ( "1000 after ten years", 1000 * EXP ( 0.05 * 10 ) )| 1000 after ten years |
|---|
| 1648.72127070013 |