March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
21 | |
19 | |
17 | |
9 | |
5 |
User | Count |
---|---|
36 | |
29 | |
16 | |
15 | |
12 |