SQRT Function (DAX)

How does the SQRT function (DAX) work?

The SQRT function (DAX) returns the square root of a number.

SQRT Formula Syntax

SQRT(
     <number>
)

How do you use the SQRT function?

This function will provide the square root of a positive number.

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

Considerations when using the SQRT function

If a number provided by a user is negative, the SQRT function will return the #NUM! error. The square root of a negative number does not exist among the set of real numbers. It is because there is no way to square a number and get a negative result.

However, if we wish to take the square root of a negative number as if it were a positive number, we need to use the ABS function. We will wrap the source number in the ABS function, which will return the absolute value of a number and ignore the positive or negative sign of the given number.

Related Video Tutorials

Formula examples using the SQRT function

=SQRT(25)

=SQRT(82.6)

=SQRT(A3)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.