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
Can you group them in PowerQuery ? (instead of in the visual)
mtrevisiolHelper V
Helper VAnonymous 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