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
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
Community SupportHi, mtrevisiol
Try formula as below:
Diff = CALCULATE(MAX(data[TimeStop]))-CALCULATE(MIN(data[TimeStart]))
Best Regards,
Community Support Team _ Eason