Forum Discussion
mtrevisiol
Helper V
Helper VDatediff between columns, grouped by users
Hi everyone. I've got this table: which contains only columns from my dataset. I've grouped it by OpID by summarizing the table selecting the oldest TimeStart and the most recent TimeStop:...
Hi, mtrevisiol
Try formula as below:
Diff = CALCULATE(MAX(data[TimeStop]))-CALCULATE(MIN(data[TimeStart]))Best Regards,
Community Support Team _ Eason
amitchandak
Super User
Super Usermtrevisiol , Try measure like
sumx(values(Table[OpId]), datediff(min(Table[prime start time]), max(Table[Ultime TimeStop])))
or
calculate(sumx(values(Table[OpId]), datediff(min(Table[prime start time]), max(Table[Ultime TimeStop]))), allexcept(Table, Table[OpId]))
mtrevisiolHelper V
Helper Vamitchandak thanks but the problem is that "Prime Time Start" and "Ultime Time Stop" are not columns. They represent the way the rows are grouped: for the oldest starttime and the most recent stoptime: