Number.Sqrt

The function returns the square root of a given number. If the number is null, the function will also return null. And if the number is negative, the function will return NaN (Not a Number).

Syntax

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

About

The function returns the square root of a given number. If the number is null, the function will also return null. And if the number is negative, the function will return NaN (Not a Number).

Explanation

Calculate the square root of 625 by using the Power Query M function Number.Sqrt(625), yielding an output of 25. To find the square root of 85, utilize the Power Query M function Number.Sqrt(85), resulting in an output of 9.2195444572928871.