The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello all,
I've created a measure for "Escalated Issues Resolution Time" - Some background: I'm creating a report which displays items and the days we take to resolve "normal" issues and "escalated" issues.
However, we've found some tickets/issues in which the escalation date listed is *after* the resolution date of said issue. There are only a handful of results that present a negative number of days--however, I'm attempting to replace these negative numbers with 0's (or even blanks would do).
Currently, my DAX for this:
Escalated Resolution Time = IF (
ISBLANK ( [Resolved Day]),
0,
( [Resolved Day] - [Escalation Day] )*1)
I've attempted to search everywhere, to make this change work--and the only result that was close to what I need:
-Adding ABS in front of "([Resolved Day] - [Escalation Day])*1)"
-However, this only changes the values to positive as you most likely know. Which effects the scoring metric we've created, that includes this measure.
Does anyone know how I might complete this change, if possible?
Solved! Go to Solution.
Thank you for the response!
I attempted this, and it was still giving me issues--However, I was able to resolve the issue by creating a column:
_Escalated_TTR = DATEDIFF ([_esclation_Date], [_Resolved_day], DAY)
Escalated Resolution Time = IF([_Escalated TTR] <=0, 0, [_Escalated TTR])
How about this?
Escalated Resolution Time =
VAR DayR = [Resolved Day]
VAR DayE = [Escalation Day]
RETURN
IF ( ISBLANK ( DayR ) || DayR < DayE, 0, ( DayR - DayE ) * 1 )
Thank you for the response!
I attempted this, and it was still giving me issues--However, I was able to resolve the issue by creating a column:
_Escalated_TTR = DATEDIFF ([_esclation_Date], [_Resolved_day], DAY)
Escalated Resolution Time = IF([_Escalated TTR] <=0, 0, [_Escalated TTR])
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
21 | |
14 | |
14 | |
9 | |
7 |