Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.