Forum Discussion
Solved
Difference btn dates with many dependences
Time Ticket Id Agent State 1/1/2020 13:48 26625 Chris Herbert created 1/2/2020 1:13 26625 Chris Herbert paused 1/2/2020 14:23 26625 Chris Herbert resumed 1/2/2020 14:25 ...
This will give diff between current and next step and then sum created, resume and reopened.
Create this as column
timediff = datediff(table[Time],minx(filter(table,table[Ticket Id] =earlier(table[Ticket Id] && table[Time] >earlier(table[Time])),table[Time]),day)
You can another column or measure an filter required steps
Appreciate your Kudos.
Still getting an error uisng earlier and including &&
Hi,
I am not sure whom you are replying to but have you tried my solution? I even share my solution file with you.
Hello Ashish Mathur
Am trying your solution by the Last_Closed - Reopened Column is returning blanks only
Thank you
Hello Ashish Mathur
Last closed-reopened = IF(ISBLANK(CALCULATE(MIN('Reports BI'[Time]),'Reports BI'[State]="reopened")),0,1440*(CALCULATE(Max('Reports BI'[Time]),'Reports BI'[State]="Closed")-CALCULATE(MIN('Reports BI'[Time]),'Reports BI'[State]="reopened"))) // This worked and provided me with solutionLastClosed_Reopened = IF(SBLANK(CALCULATE(MIN('Reports BI'[Time]),'Reports BI'[State]="reopened")),DATEDIFF(CALCULATE(MIN('Reports BI'[Time]),'Reports BI'[State]="reopened"),CALCULATE(MAX('Reports BI'[Time]),'Reports BI'[State]="closed"),MINUTE)) // This is giving me blanksI cant figure out the difference betweenAnd thank you, your solution provided me with the answerYou are welcome.
Hi,
I can't say why. It is working fine in the file i shared with you.