LOG

Updated on

LOG is a DAX function that returns the logarithm of a number to a specified base.

Syntax

LOG(
   Number,
   Base
)
Argument Properties Description
Number The positive number for which you want the logarithm.
Base Optional The base of the logarithm; if omitted, 10.

Return Values

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)

Other functions related to LOG are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/log-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy