How does the SQRT function (DAX) work?
The SQRT function (DAX) returns the square root of a number.
SQRT Formula Syntax
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
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