Assistance with DAX Measure

[tayriley88]

Hello,

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.

Months passed since start of FY = 8

Current Metric Average = 6.79%

Months till end of FY=4

Goal = 6%

Formula I have found to work is:

8(6.79)+4(x)/12=6

53.32 + 4(x)=72

4(x)=17.68

x=4.42% average needed to each month to hit the 6% goal.

Is this possible to convert to DAX?

Thank you in advance!