Fabric Plan Community Logo
Sign in

LOG

The LOG function returns the logarithm of a number using a specified base. It calculates the exponent to which the base must be raised to produce the given number. This function is commonly used in mathematical, financial, and scientific calculations involving exponential relationships or scale transformations.

Syntax

LOG(value, base)

Arguments

  • value: The positive real number for which to calculate the logarithm.
  • base: The base of the logarithm.

Return value

Returns the logarithm of the specified value for the given base.

Example

LOG(Sales, 10)

In this example, the LOG function is used to create the Log_Sales measure, which returns the logarithm of the values in the Sales measure using base 10.

Excel equivalent

LOG

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.