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 formula, but i am not getting anywhere.

 

can anyone advise the best dax forumula i can use please?

 

Thanks

 

DATEDIFF
if
time functions

1 Reply

  • 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])