Skip to main content
cancel
Showing results for 
Search instead 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

Reply
ymirza
Helper II
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

 

TaskCreated
Opened 01-Dec
Closed02-Dec
Closed02-Dec
Closed04-Dec
Opened 05-Dec
Opened 06-Dec
Opened 07-Dec

 

I will use Card to display this count

1 ACCEPTED SOLUTION

@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)

View solution in original post

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

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?

@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)

Thanks Affan for the quick support

Helpful resources

Announcements
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

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