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

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.