Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hello All,
@Amit, @Greg , @tamerj1 , @lbendlin
I am struggling to write a DAX code for my Measure called Rating 3 where it dynamically calculates whether Performance(SOL_KPI) is at 85% of Target(which is 75%) for the last 3 out of 4 months.
My current Line & Clustered Column Chart looks like this:
As you can see, the SOL_KPI(Performance) is increasing towards Target for the last couple of months but significantly behind Target.
The DAX code should be written in such a way that as the data refreshes for the next couple of months like August, September, October, it should dynamically calculate Rating 3.
The Dates Table is an artificial Calendar table I created using CalendarAuto function or I simply imported from the internal database which shows nothing but dates for this current year.
Can you please suggest me any help here?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
8 | |
6 | |
4 | |
3 |