Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |