SQRTPI Function (DAX)

How does the SQRTPI function (DAX) work?

The SQRTPI function (DAX) returns the square root of (number * pi).

SQRTPI Formula Syntax

SQRTPI(
     number
)

How do you use the SQRTPI function?

This function is used to return the square root of the pi constant (3.14159265358979) multiplied by the specified number.

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
Nulls/Blanks DAX Measure

Considerations when using the SQRTPI function

Sqrtpi Function Errors

If you get an error from the SQRTPI Function, this is likely to be one of the following: Common Errors

#NUM!Occurs if the supplied number is < 0.
#VALUE!Occurs if the supplied number argument is non-numeric.

Related Video Tutorials

Formula examples using the SQRTPI function

=SQRTPI(2)

=SQRTPI(1)

=SQRTPI( 100 )

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership