Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
When I'm computing POWER(-0.93, 0.08) I'm getting this error:
An argument of function 'POWER' has the wrong data type or the result is too large or too small.
Why DAX can't compute it?
The values don't seem to be too large or small.
The Windows calculator is returning me 0.99 as the result.
Solved! Go to Solution.
If you have both positive and negative numbers in a column you can use:
Column = SIGN([Column1]) * POWER(ABS([Column1]),0.08)
This is also an issue with the T.DIST.2T function -- if you feed it negative X to evaluate, it returns this error. ABS(X) beforehand solved this for me. Thanks.
If you have both positive and negative numbers in a column you can use:
Column = SIGN([Column1]) * POWER(ABS([Column1]),0.08)
What if there are no negative numbers? I have the following formula which is not working
Hi , Instead power you should use this, (([total Visitors in 2019])^(1/3)/([total Visitors in 2016])^(1/3))-1)
I have two caluclated measures in columns...[2020] and [2014]. I want to compute the CAGR and there are sign changes. I would like the end result to be [2020]/[2014]^(1/6)-1, but I get the Argument of function Power has the wrong data type...
How to I use your sign changes fix in a measure that calcualtes two columns?
The issue is that you are doing a root of a negative number which will return a complex result.
The order of opperations is why google is giving you a result but what it is actually doing is -(0.93^0.08)
If you put (-0.93)^0.08 into google you will get what the POWER function is attempting which is 0.962976193 + 0.247250262 i
As far as I am aware Power BI has no support for complex or imaginary numbers. If you do want the result of -(0.93^0.08) then use the following
Measure = -1 * POWER ( -0.93, 0.08 )
or
-1 * ( 0.93 ^ 0.08 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |