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