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.

Matic20's avatar
Matic20
Frequent Visitor
6 years ago

Still getting an error uisng earlier and including &&

 

Matic20's avatar
Matic20
Frequent Visitor
6 years ago

Hello Ashish Mathur

 

Am trying your solution by the Last_Closed - Reopened Column is returning blanks only 

 

Thank you 

  • Matic20's avatar
    Matic20
    Frequent Visitor
    6 years ago

    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 solution 
     
    LastClosed_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 blanks
     
    I cant figure out the difference between 
     
    And thank you, your solution provided me with the answer 
     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      You are welcome.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    I can't say why.  It is working fine in the file i shared with you.