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

working correctlysame formula as net_sales but throwing error

3 Replies

  • 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]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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