Forum Discussion
Work out difference in time between events
I have a table which looks like the below. This details actions taken for finance applications, where there can be multiple action types per application. The application ID identifies t...
m_richardson , Try like
Measure =
var _min = calculate(min(Table[Date Time], allexcept(Table, table[Application ID]), filter(Table, Table[Application Type] = "Application Start"))
Var _max = calculate(max(Table[Date Time], allexcept(Table, table[Application ID]), filter(Table, Table[Application Type] = "Paidout"))
return
averagex(Values(Table[Application ID]), datediff(_min, _max, minute))
Apologies for the delay, but this doesn't work. The parentheses don't match up, and I'm getting an error that MIN only needs two arguments passing to it.