Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
5 years ago

SUM Time Field

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  
Data Protection
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
HenryJS
Post Prodigy
5 years ago

Anonymous this summarised the rest times and gave the same value for everyone - please see below

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.