SQRTPI DAX Function (Math and Trig)
Returns the square root of (number * pi).
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Number |
The number by which pi is multiplied. |
Return values
Returns the square root of (number * π).
Remarks
The Microsoft documentation and IntelliSense use “pi” as an alias for π.
Examples
-- SQRTPI computes the square root of the value multiplied by Pi
-- PI returns the value of Pi with 15 digits of accuracy
DEFINE
VAR Vals = GENERATESERIES ( 1, 25, 3 )
EVALUATE
ADDCOLUMNS (
Vals,
"SQRTPI", SQRTPI ( [Value] ),
"SQRT and PI", SQRT ( [Value] * PI () )
)
| Value | SQRTPI | SQRT and PI |
|---|---|---|
| 1 | 1.77 | 1.77 |
| 4 | 3.54 | 3.54 |
| 7 | 4.69 | 4.69 |
| 10 | 5.60 | 5.60 |
| 13 | 6.39 | 6.39 |
| 16 | 7.09 | 7.09 |
| 19 | 7.73 | 7.73 |
| 22 | 8.31 | 8.31 |
| 25 | 8.86 | 8.86 |
Related functions
Other related functions are:
Last update: Nov 5, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber,
Microsoft documentation: https://docs.microsoft.com/en-us/dax/sqrtpi-function-dax
