topic Re: problem with POWER function in DAX Commands and Tips

problem with POWER function

Anonymous — Wed, 11 Sep 2019 06:07:34 GMT

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

Re: problem with POWER function

SteveCampbell — Fri, 13 Sep 2019 02:26:02 GMT

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

Re: problem with POWER function

Anonymous — Wed, 13 Nov 2019 11:17:19 GMT

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

Re: problem with POWER function

Anonymous — Fri, 10 Sep 2021 17:46:53 GMT

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