Syntax Error

[faheem_Latif_BI]

Hi All,

What is wrong wih this DAX , thanks in advance:

Reforecast CAGR = (DIVIDE([CurrentYearBudget],[MinYearActual],0)^DIVIDE(1,([CountYearsByActual] +1),0) -1)

Error Message:
MdxScript(Model) (22, 39) Calculation error in measure 'BudgetView'[Reforecast CAGR]: An argument of function 'POWER' has the wrong data type or the result is too large or too small.

[amitchandak]

@faheem_Latif_BI , Try like

Power (DIVIDE([CurrentYearBudget],[MinYearActual],0), DIVIDE(1,([CountYearsByActual] +1),0)) -1

Check the datatype of CountYearsByActual and CurrentYearBudget, MinYearActual. all should be number