Number.Log10
The base-10 logarithm: the power 10 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.Log10(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 10; minus infinity for 0, NaN for a negative number; null for null.
Examples
A thousand
Number.Log10(1000)3A hundredth
Number.Log10(0.01)-2How many digits a whole number has
Number.RoundDown(Number.Log10(48500)) + 15