Forum Discussion

tayriley88's avatar
tayriley88
Frequent Visitor
7 years ago

Assistance with DAX Measure

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!

No RepliesBe the first to reply