Number.Sqrt

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 )

Related functions

Other functions related to Number.Sqrt are:

• Number.Abs
• Number.Combinations
• Number.Exp
• Number.Factorial
• Number.IntegerDivide
• Number.Ln
• Number.Log
• Number.Log10
• Number.Mod
• Number.Permutations
• Number.Power
• Number.Sign

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