https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-exponential-operator/m-p/3448716#M131304 <P><A href="https://learn.microsoft.com/en-us/dax/power-function-dax" target="_blank">POWER function (DAX) - DAX | Microsoft Learn</A></P> Wed, 27 Sep 2023 00:25:23 GMT lbendlin 2023-09-27T00:25:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-exponential-operator/m-p/3446170#M131119 <P>I have data in excel that i'm trying to transfer into a BI report. However, i'm stuck with one formula =(YEAR/YEAR)^(1/YEAR-YEAR (<EM>pulled from an already determined formula</EM>))-1</P><P>&nbsp;</P><P>Or Cell A1 =2019-2015</P><P>&nbsp;</P><P>=(2019/2015)^(1/A1)-1</P><P>&nbsp;</P><P>Appreciate any help.</P> Mon, 25 Sep 2023 15:02:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-exponential-operator/m-p/3446170#M131119 Dorset_Steve 2023-09-25T15:02:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-exponential-operator/m-p/3448716#M131304 <P><A href="https://learn.microsoft.com/en-us/dax/power-function-dax" target="_blank">POWER function (DAX) - DAX | Microsoft Learn</A></P> Wed, 27 Sep 2023 00:25:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-exponential-operator/m-p/3448716#M131304 lbendlin 2023-09-27T00:25:23Z