https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Syntax-Error/m-p/2788617#M87493 <P>Hi All,</P><P>What is wrong wih this DAX , thanks in advance:</P><P>&nbsp;</P><P>Reforecast CAGR = <SPAN>(</SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN><SPAN>[CurrentYearBudget]</SPAN>,<SPAN>[MinYearActual]</SPAN>,<SPAN>0</SPAN><SPAN>)</SPAN>^<SPAN>DIVIDE</SPAN><SPAN>(</SPAN><SPAN>1</SPAN>,<SPAN>(</SPAN><SPAN>[CountYearsByActual]</SPAN> +<SPAN>1</SPAN><SPAN>)</SPAN>,<SPAN>0</SPAN><SPAN>)</SPAN> -<SPAN>1</SPAN><SPAN>)</SPAN></P><P>&nbsp;</P><P><SPAN>Error Message:<BR />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.<BR /></SPAN></P> Fri, 23 Sep 2022 06:26:16 GMT faheem_Latif_BI 2022-09-23T06:26:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Syntax-Error/m-p/2788617#M87493 <P>Hi All,</P><P>What is wrong wih this DAX , thanks in advance:</P><P>&nbsp;</P><P>Reforecast CAGR = <SPAN>(</SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN><SPAN>[CurrentYearBudget]</SPAN>,<SPAN>[MinYearActual]</SPAN>,<SPAN>0</SPAN><SPAN>)</SPAN>^<SPAN>DIVIDE</SPAN><SPAN>(</SPAN><SPAN>1</SPAN>,<SPAN>(</SPAN><SPAN>[CountYearsByActual]</SPAN> +<SPAN>1</SPAN><SPAN>)</SPAN>,<SPAN>0</SPAN><SPAN>)</SPAN> -<SPAN>1</SPAN><SPAN>)</SPAN></P><P>&nbsp;</P><P><SPAN>Error Message:<BR />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.<BR /></SPAN></P> Fri, 23 Sep 2022 06:26:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Syntax-Error/m-p/2788617#M87493 faheem_Latif_BI 2022-09-23T06:26:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Syntax-Error/m-p/2789136#M87512 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="439965" data-lia-user-login="faheem_Latif_BI" class="lia-mention lia-mention-user">faheem_Latif_BI</a> , Try like</P> <P>&nbsp;</P> <P>Power (DIVIDE([CurrentYearBudget],[MinYearActual],0), DIVIDE(1,([CountYearsByActual] +1),0)) -1</P> <P>&nbsp;</P> <P>Check the datatype of CountYearsByActual and CurrentYearBudget, MinYearActual. all should be number</P> Fri, 23 Sep 2022 08:41:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Syntax-Error/m-p/2789136#M87512 amitchandak 2022-09-23T08:41:41Z