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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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