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


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


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).


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:

BI Gorilla Blog

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.