PI DAX Function (Math and Trig)
Returns the value of π, 3.14159265358979, accurate to 15 digits.
Syntax
This expression has no parameters.
Return values
A decimal number with the value of π, 3.14159265358979, accurate to 15 digits.
Remarks
π is a mathematical constant. In DAX, π is represented as a real number accurate to 15 digits, the same as the function PI in Excel.
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 |
Last update: Nov 7, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/pi-function-dax