Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi Folks,
I have an issue in Dax funtion SQRT.
This is the error it is returning.
The measure we hade is supposed return the square root of product of 2 measure values.
Measure = SQRT([Part1] * [PART2])
This error is happening for the below mentioned values
Examples.
Please help me in solving this issue
Thanks
Mahesh R
Solved! Go to Solution.
Hi @Anonymous ,
Please update the formula of Measure as below and check whether you can get the expected result:
Measure = SQRT ( ABS ( [Part1] * [PART2] ) )
SQRT problem in DAX/excel - too many decimal places?
Handling Errors in DAX Expressions
Best Regards
Hi @Anonymous ,
Please update the formula of Measure as below and check whether you can get the expected result:
Measure = SQRT ( ABS ( [Part1] * [PART2] ) )
SQRT problem in DAX/excel - too many decimal places?
Handling Errors in DAX Expressions
Best Regards
Those are big numbers. Perhaps:
Measure = CALCULATE(SQRT([Start1]*[START2]), [Start1] >0)
--Nate
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
85 | |
66 | |
49 |
User | Count |
---|---|
140 | |
113 | |
104 | |
64 | |
60 |