PI DAX Function (Math and Trig)

Syntax  |  Return values  |  Remarks  |  Examples  

Returns the value of π, 3.14159265358979, accurate to 15 digits.

Syntax

PI ( )

This expression has no parameters.

Return values

Scalar A single decimal value.

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 14, 2024   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/pi-function-dax