Number.Sqrt
The square root of a number: the value that multiplied by itself gives the number.
Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Number.Sqrt(number as nullable number) as nullable number| Parameter | Type | Description |
|---|---|---|
number | nullable number | The number to work on; null gives null. |
Returns
nullable number. The positive square root; NaN for a negative number; null for null.
Examples
The side of a square shop floor of 144 m²
Number.Sqrt(144)12An irrational root
Number.Sqrt(2)1.4142135623730951A negative number has no real root
Number.Sqrt(-1)#nan