Reply
shreep1
Helper III
Helper III
Partially syndicated - Outbound

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
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)