problem with POWER function

[Anonymous]

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 got the above error

working correctlysame formula as net_sales but throwing error

[Anonymous]

I have the same problem. Has anyone been able to find the solution ?

[SteveCampbell]

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]

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]))