- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
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?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-15-2024 01:27 AM | |||
03-07-2024 12:19 PM | |||
07-24-2023 02:32 PM | |||
04-03-2023 06:36 AM | |||
02-06-2024 02:13 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |