Number.Exp
The number e, about 2.718, raised to a power: growth that compounds continuously.
Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Number.Exp(number as nullable number) as nullable number| Parameter | Type | Description |
|---|---|---|
number | nullable number | The number to work on; null gives null. |
Returns
nullable number. e to the power of the number; null for null.
Examples
e itself
Number.Exp(1)2.7182818284590451,000 growing 5 % a year, compounded continuously for three years
Number.Round(1000 * Number.Exp(0.05 * 3), 2)1161.83