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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.