Number.Ln
The natural logarithm: the power e must be raised to for the number.
Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Number.Ln(number as nullable number) as nullable number| Parameter | Type | Description |
|---|---|---|
number | nullable number | The number to work on; null gives null. |
Returns
nullable number. The logarithm to base e; minus infinity for 0, NaN for a negative number; null for null.
Examples
It undoes Number.Exp
Number.Ln(Number.Exp(2))2Years to double at 5 % continuous growth
Number.Round(Number.Ln(2) / 0.05, 2)13.86