Forum Discussion
tayriley88
7 years agoFrequent Visitor
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