LOG10
Logarithm in base 10 of the number: LOG10(1000) is 3.
Group: Math. Compatible with DAX.
Syntax
LOG10 ( <number> )| Parameter | Type | Description |
|---|---|---|
number | Number | A number above 0. |
Returns
Number. The power 10 must be raised to in order to give the number.
Remarks
- 0 and negative numbers are errors. A blank gives minus infinity (-Infinity).
- Powers of ten come out exact:
LOG10 ( 1000 )is 3 andLOG10 ( 0.01 )is -2. - The number of digits of a whole number n of 1 or more is
INT ( LOG10 ( n ) ) + 1.
Examples
Logarithms in base 10
EVALUATE
ROW (
"Of 1000", LOG10 ( 1000 ),
"Of 0.01", LOG10 ( 0.01 ),
"Of 50", LOG10 ( 50 )
)| Of 1000 | Of 0.01 | Of 50 |
|---|---|---|
| 3 | -2 | 1.69897000433602 |
Digits of a number
EVALUATE
ROW ( "Digits of 12345", INT ( LOG10 ( 12345 ) ) + 1 )| Digits of 12345 |
|---|
| 5 |