The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
8 | |
8 |