SUM Time Field

[HenryJS]

Hi all,

Is it possible to SUM a Time field?

Below I have summed [Rest Time 2] but instead of correctly adding up the times it gives an incorrect time

[V-pazhen-msft]

@HenryJS 

You cannot get the sum of the time value with Groupby() table because currentgroup() is referring to the current row instead of all(table). 

Try use summarize():

Table = Summarize('Engage Timesheet Export',
                  'Engage Timesheet Export'[Worker Name],
                  'Engage Timesheet Export'[Week Ending],
                  "Total Rest Time",Sumx(All('Engage Timesheet Export'),[Rest Time2]))

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HenryJS]

@V-pazhen-msft this summarised the rest times and gave the same value for everyone - please see below

[V-pazhen-msft]

@HenryJS 
I guess I misunderstood you requirement. I only see the incorrect sum time. You may add filters to set context.

Table = Summarize('Engage Timesheet Export',
                  'Engage Timesheet Export'[Worker Name],
                  'Engage Timesheet Export'[Week Ending],
                  "Total Rest Time",Sumx(All('Engage Timesheet Export'),[Rest Time2]))

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[watkinnc]

Hey there. I find that when dealing with time, it's always best to use a decimal number for times, instead of actual times; especially when adding and subtracting. My advice would be to change your time column to type number, write the measure, and then change the measure display type to h:mm:ss or if the sum is over 24 hrs, [H]:mm:ss. Should work!

[amitchandak]

@HenryJS , refer if these blogs can help

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...

https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...