Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to Solution.
@efowler ,Try modify Days Open measure as below.
Days Open = if([Resolution Time]>0, blank(),
DATEDIFF('cases'[Created Date],TODAY(),DAY))
@efowler ,Try modify Days Open measure as below.
Days Open = if([Resolution Time]>0, blank(),
DATEDIFF('cases'[Created Date],TODAY(),DAY))
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |