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

The 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.

Reply
efowler
Helper II
Helper II

Question on resolution time vs days open with two dates + status

Hello, 

 

I have a report that shows case "Status", created date, resolved date..   I need to show two columns as shown below.   Is it possible to filter the "days open" to only show values when the case is NOT resolved?   

 

I would like resolution column to show the days it took to resolve the case and it correctly shows this data when a case is resolved. 

 

The issue is the "days open" column includes resolved cases and is not what I intend to show. 

 

Days open is a calculated column --> Days Open = DATEDIFF('cases'[Created Date],TODAY(),DAY)

Resolution time is a caluclated column --> Resolution Time = DATEDIFF('cases'[c_Date_Time],'cases'[r_Date_Time],DAY)

 

in the image the red colored boxes should show no value since the case is resolved and the resolution column contains the data

table showing case days open and resolution time.jpg

1 ACCEPTED SOLUTION
Jeanxyz
Impactful Individual
Impactful Individual

@efowler ,Try modify Days Open measure as below.

 

 Days Open = if([Resolution Time]>0, blank(),

DATEDIFF('cases'[Created Date],TODAY(),DAY))

View solution in original post

1 REPLY 1
Jeanxyz
Impactful Individual
Impactful Individual

@efowler ,Try modify Days Open measure as below.

 

 Days Open = if([Resolution Time]>0, blank(),

DATEDIFF('cases'[Created Date],TODAY(),DAY))

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.