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
if you want it per OpID
i will try calculated columns : (if you want it in minutes)
diff =
DATEDIFF([Ultime TimeStop] ), [Prime TimeStart]), MINUTE )
mtrevisiolHelper V
Helper VAnonymous
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:
Can you group them in PowerQuery ? (instead of in the visual)
- mtrevisiol
Anonymous maybe I can duplicate the table and then modify it in PowerQuery. How do tou suggest to do it?
- v-easonf-msft
Community Support
Hi, mtrevisiol
Try formula as below:
Diff = CALCULATE(MAX(data[TimeStop]))-CALCULATE(MIN(data[TimeStart]))Best Regards,
Community Support Team _ Eason