cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Measure for Count of opened items older than 60 days

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

1 ACCEPTED SOLUTION
Solution Sage

@ymirza

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)```
4 REPLIES 4
Solution Sage

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

Helper II

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?

Solution Sage

@ymirza

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)```
Helper II

Thanks Affan for the quick support

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors