Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
shreep1
Helper III
Helper III

How to find Performance is at 85% of Target(which is 75%) for the last 3 out of 4 months DAX code

Hello All,

 

 @Amit@Greg , @tamerj1 , @lbendlin 

@ HenriqueReis

 @  d_gosbell

 

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:

 

shreep1_0-1690206845151.png

 

 

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?

 

0 REPLIES 0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.