Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DATEDIFF between DateTime Values by ID

I have a Table_A, which tracks the DateTime of status changes. DateTime ID Entry Exit 29/10/2020 14:25 1001 1 0 01/12/2020 15:30 1002 1 0 05/02/2021 12:00 1001 0 1 15/...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a measure like

     

    averageX(values(Table[ID]), calculate(datediff(minx(filter(Table, Table[Entry] =1), [DateTime]),maxx(filter(Table, Table[exit] =1), [DateTime]),minute)))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you both for getting back to me. I'll try out the solutions and get back to you 🙂