Forum Discussion

Matic20's avatar
Matic20
Frequent Visitor
6 years ago
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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

Matic20's avatar
Matic20
Frequent Visitor
6 years ago

So far this what  i have 

Earliest_Closed_Created =
DATEDIFF(CALCULATE(MIN('Reports BI'[Time]),'Reports BI'[State] = "created"),CALCULATE(MIN('Reports BI'[Time]),'Reports BI'[State] = "closed"),MINUTE)
 
Resumed_Paused = DATEDIFF(CALCULATE(MIN('Reports BI'[Time]),'Reports BI'[State] = "paused"),CALCULATE(MIN('Reports BI'[Time]),'Reports BI'[State] = "resumed"),MINUTE)
 
LastClosed_Reopened = IF(
ISBLANK(
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))
 
LastClosed_Reopened is returnining on;y blanks 
Earliest_Closed_Created and LastClosed_Reopened are so far returning the correct information