Updated on

Number.Ln is a Power Query M function that calculates the natural logarithm of a given number. The function returns the natural logarithm value or null if the input number is null.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Number.Ln( number as nullable number ) as nullable number


Returns the natural logarithm of a number, number. If number is null Number.Ln returns null.


Get the natural logarithm of 15.

// Output: 2.70805020110221
Number.Ln( 15 )

Other functions related to Number.Ln are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: