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

Anonymous — Mon, 24 Jul 2023 13:56:09 GMT

Hello All,

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?

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

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