Forum Discussion

mda's avatar
mda
Icon for Advocate I rankAdvocate I
8 years ago
Solved

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

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 v...
  • Greg_Deckler's avatar
    8 years ago

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

     

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