Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am looking for DAX that will count the number of Opened tasks that are older than 60 days
I have this simple table below
Task | Created |
Opened | 01-Dec |
Closed | 02-Dec |
Closed | 02-Dec |
Closed | 04-Dec |
Opened | 05-Dec |
Opened | 06-Dec |
Opened | 07-Dec |
I will use Card to display this count
Solved! Go to Solution.
As your data is only showing the values from Dec, so no values befor 60 days. To avoid the blank in the count measure use below measure instead.
Measure = var _count=CALCULATE(COUNTROWS(Table1),Table1[Task]="Opened" , Table1[Created]<=TODAY()-60) return IF(ISBLANK(_count),0,_count)
Hi @ymirza,
You can use the below measure
Measure = CALCULATE(COUNTROWS(Table1),Table1[Task]="Opened" , Table1[Created]<=TODAY()-60)
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
Hi @affan thanks for quick response. Yes this is what I need but right now the value returned is "Blank", how do I have Zero or '0' in the count?
As your data is only showing the values from Dec, so no values befor 60 days. To avoid the blank in the count measure use below measure instead.
Measure = var _count=CALCULATE(COUNTROWS(Table1),Table1[Task]="Opened" , Table1[Created]<=TODAY()-60) return IF(ISBLANK(_count),0,_count)
Thanks Affan for the quick support
User | Count |
---|---|
128 | |
73 | |
70 | |
58 | |
53 |
User | Count |
---|---|
193 | |
96 | |
66 | |
62 | |
52 |