Table of contents
TOC
Collapse the table of content
Expand the table of content

LOG Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

Returns the logarithm of a number to the base you specify.

Syntax

LOG(<number>,<base>)  

Parameters

TermDefinition
numberThe positive number for which you want the logarithm.
baseThe base of the logarithm. If omitted, the base is 10.

Return Value

A decimal number.

Remarks

You might receive an error if the value is too large to be displayed.

The function LOG10 is similar, but always returns the common logarithm, meaning the logarithm for the base 10.

Example

The following formulas return the same result, 2.

=LOG(100,10)  
=LOG(100)  
=LOG10(100)  

See Also

Math and Trig Functions (DAX)
EXP Function (DAX)
LOG Function (DAX)
LOG Function (DAX)

© 2018 Microsoft