https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Assistance-with-DAX-Measure/m-p/699809#M771 <P>Hello,</P><P>&nbsp;</P><P>I'm looking to convert a formula to DAX and running into a bit of an issue. Formula is to grab the average needed to hit a metric for the remained of the FY.</P><P>&nbsp;</P><P>Months passed since start of FY = 8</P><P>Current Metric Average = 6.79%</P><P>Months till end of FY=4</P><P>Goal = 6%</P><P>&nbsp;</P><P>Formula I have found to work is:</P><P>8(6.79)+4(x)/12=6</P><P>53.32 + 4(x)=72</P><P>4(x)=17.68</P><P>x=4.42% average needed to each month to hit the 6% goal.</P><P>&nbsp;</P><P>Is this possible to convert to DAX?</P><P>&nbsp;</P><P>Thank you in advance!</P> Sat, 25 May 2019 14:53:20 GMT tayriley88 2019-05-25T14:53:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Assistance-with-DAX-Measure/m-p/699809#M771 <P>Hello,</P><P>&nbsp;</P><P>I'm looking to convert a formula to DAX and running into a bit of an issue. Formula is to grab the average needed to hit a metric for the remained of the FY.</P><P>&nbsp;</P><P>Months passed since start of FY = 8</P><P>Current Metric Average = 6.79%</P><P>Months till end of FY=4</P><P>Goal = 6%</P><P>&nbsp;</P><P>Formula I have found to work is:</P><P>8(6.79)+4(x)/12=6</P><P>53.32 + 4(x)=72</P><P>4(x)=17.68</P><P>x=4.42% average needed to each month to hit the 6% goal.</P><P>&nbsp;</P><P>Is this possible to convert to DAX?</P><P>&nbsp;</P><P>Thank you in advance!</P> Sat, 25 May 2019 14:53:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Assistance-with-DAX-Measure/m-p/699809#M771 tayriley88 2019-05-25T14:53:20Z