Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
82 | |
65 | |
64 | |
56 |
User | Count |
---|---|
171 | |
111 | |
109 | |
72 | |
71 |