Number.Sqrt

Updated on

Number.Sqrt is a Power Query M function that returns the square root of a given number. The function returns null if the input is null, and Number.NaN if the input is a negative value.

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

Syntax

Number.Sqrt( number as nullable number ) as nullable number

Description

Returns the square root of number. If number is null, Number.Sqrt returns null. If it is a negative value, Number.NaN is returned (Not a number).

Examples

Find the square root of 625.

// Output: 25
Number.Sqrt( 625 )

Find the square root of 85.

// Output: 9.2195444572928871
Number.Sqrt( 85 )

Other functions related to Number.Sqrt are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/number-sqrt