Forum Discussion

EloiseJane's avatar
EloiseJane
Frequent Visitor
6 years ago

date diff if case open

Hi    I am trying to establish an average case processing time for closed cases. I have 3 columns: Start Date/Completed date & Status(open/closed)   I am tring to use a CALCUALTE/DATEDIFF/FILTER ...
DATEDIFF
if
time functions
M_L's avatar
M_L
Frequent Visitor
6 years ago

Hello, Let me know if this works in your table

 

Average time =

    AVERAGEX(
FILTER('Table';'Table'[Status]="closed");
'Table'[Completed Date]-'Table'[Start Date])