LOG10 DAX Function (Math and Trig)

Syntax  |  Return values  |  Remarks  |  Examples  |  Related  

Returns the base-10 logarithm of a number.

Syntax

LOG10 ( <Number> )

Parameter	Attributes	Description
Number		The positive number for which you want the base-10 logarithm.

Return values

Scalar A single decimal value.

Logarithm of number to base 10.

Remarks

Using LOG10 is a shortcut for using LOG using the base 10 as second argument.

» 1 related function

Examples

--  Logarithmic functions include LOG10, LN, LOG, and EXP to compute
--  logarithms using various bases or exponential.
DEFINE
    VAR Vals = GENERATESERIES ( 1, 25, 4 )
EVALUATE
ADDCOLUMNS ( 
    Vals,
    "LN",       LN      ( [Value] ),
    "LOG10",    LOG10   ( [Value] ),
    "LOG 5",    LOG     ( [Value], 5 ),
    "EXP",      EXP     ( [Value] )
)

Value	LN	LOG10	LOG 5	EXP
1	0.00	0.00	0.00	2.72
5	1.61	0.70	1.00	148.41
9	2.20	0.95	1.37	8,103.08
13	2.56	1.11	1.59	442,413.39
17	2.83	1.23	1.76	24,154,952.75
21	3.04	1.32	1.89	1,318,815,734.48
25	3.22	1.40	2.00	72,004,899,337.39

Related functions

Other related functions are:

• LOG

Last update: Jun 13, 2021   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/log10-function-dax