date diff if case open

EloiseJane — Thu, 14 Nov 2019 10:38:07 GMT

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

Re: date diff if case open

M_L — Thu, 14 Nov 2019 22:14:51 GMT

Hello, Let me know if this works in your table

Average time =

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