Forum Discussion

pawlowski6132's avatar
pawlowski6132
Icon for Helper V rankHelper V
5 years ago

TimeBetween function or similar?

So, I'm familiar with the DatesBetween function. I need similar results but, using Time.   For example, we have a use case wherein we have hours worked data for each hour of the day:   Start 2:00...
Help
Radhika2605's avatar
Radhika2605
Icon for Helper II rankHelper II
5 years ago

Hi pawlowski6132 ,

 

I think you can utilize the cumulative total concept. 

 

Total Hours = Sum( [Hours] ) 

 

Calculate([Total Hours],
Filter( 'Table', Table[Time] < Max( Table[Time] ) ) )

 

So this will give you a total of how many hours are worked. You can also add a filter for the day like - 

Calculate([Total Hours],
Filter( 'Table', Table[Time] < Max( Table[Time] ) ,
Filter ('Table', [Date] = Max([Date]) ) ) )

 

Hope this helps. 

 

Thanks

Radhika