Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

problem with POWER function

i m getting Error lik this : An argument of function 'POWER' has the wrong data type or the result is too large or too small.   But for the net_sales it is not throwing any error. but for EBITDA go...
SteveCampbell's avatar
SteveCampbell
Memorable Member
6 years ago

Hard to say without more information. Could the expression be negative?
Also, as a tip, use the DIVIDE function instead of the / operator, as divide has built in error handling.

 

You could try wrapping in a MIN funcion, e.g:

 

... POWER (( MIN (  DIVIDE ([columnA] , [columnB]) ) , 0.5 ) ....

 

Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!

Stay up to date on  
Read my blogs on  

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    I tried everything. but still it is not working
     
    POWER([EBITDA CAGR],0.5)
     
    EBITDA CAGR = DIVIDE(SUM('Merge2-Used for Earnings Monitor Tbale Format'[EBITDA_FY20]),SUM('Merge2-Used for Earnings Monitor Tbale Format'[EBITDA_FY18]))