Returns the logarithm of an expression to a specified base.
Syntax
Log ( numeric_value_expression [,base] )
| Parameter | Description |
|---|---|
numeric_value_expression | A numeric value or an expression that returns a numeric value (see MDX Grammar Rules). |
base | Optional. A number representing the base to use for the logarithm. If less than zero, zero, or close to 1, the Log function returns #MISSING. If omitted, the Log function calculates the base-10 logarithm. Log (Sales, 10) is equivalent to Log(Sales), and is also equivalent to Log10(Sales). |
Example
Log(9,3) returns 2.