LN
The natural logarithm of a number.
Group: Math. Compatible with DAX.
Syntax
LN ( <number> )
| Parameter | Type | Description |
|---|
number | Number | A number above 0. |
Returns
Number. The natural logarithm: the power e must be raised to in order to give the number.
- 0 and negative numbers are errors.
- A blank gives minus infinity (-Infinity), neither BLANK nor an error. Filter out blanks first where they can occur.
- LN and
EXP undo each other.
- Logarithms turn growth into time: at 7 % a year an amount doubles in
LN ( 2 ) / LN ( 1.07 ) years, a little over 10.
Examples
Natural logarithms
EVALUATE
ROW (
"Of e squared", LN ( EXP ( 2 ) ),
"Of 1", LN ( 1 ),
"Of 10", LN ( 10 )
)
| Of e squared | Of 1 | Of 10 |
|---|
| 2 | 0 | 2.30258509299405 |
Years to double at 7 %
EVALUATE
ROW ( "Years", LN ( 2 ) / LN ( 1.07 ) )
LN of a blank value
EVALUATE
ROW ( "Of blank", LN ( BLANK () ) )
LOG, LOG10, EXP.
Last updated · OpenBI Studio 0.3.74