An argument of function 'POWER' has the wrong data type or the result is too large or too small.

[mda]

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.

[Anonymous]

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.

[Greg_Deckler · Accepted solution]

If you have both positive and negative numbers in a column you can use:

Column = SIGN([Column1]) * POWER(ABS([Column1]),0.08)

[Anonymous]

What if there are no negative numbers? I have the following formula which is not working

CAGR = POWER([total Visitors in 2019]/[total Visitors in 2016], (1/3))-1.

Please let me know how to fix this issue.

[hananrao4]

Hi , Instead power you should use this, (([total Visitors in 2019])^(1/3)/([total Visitors in 2016])^(1/3))-1) 

[Anonymous]

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?

[Anonymous]

I have the same problem. Is this cause i used two calculated measures as my x and y axes? What does wrong data type mean?

[Anonymous]

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 )