Forum Discussion
Time between shift finish time and next shift start time
Hi, Trying to find the "Break Time" between the shift finish time & the next shift start time per employee. Attached is an excample of the shifts worked by one employee in a typical day. Sample...
CNENFRNL I would like the results from your calculated column 'shifted' up a row.
Instead of the first row blank, the last should be blank.
I've been tinkering with your formula but havebeen unable to achieve this.
Time Between Calls =
VAR __prev =
MAXX (
TOPN (
1,
FILTER (
'powerbi114 view_finance',
'powerbi114 view_finance'[carer_id]
= EARLIER ( 'powerbi114 view_finance'[carer_id] )
&& 'powerbi114 view_finance'[Date] = EARLIER ( 'powerbi114 view_finance'[Date] )
&& 'powerbi114 view_finance'[Finish Time]
<= EARLIER ( 'powerbi114 view_finance'[Start Time] )
),
'powerbi114 view_finance'[Finish Time]
),
'powerbi114 view_finance'[Finish Time]
)
RETURN
IF ( NOT ISBLANK ( __prev ), 'powerbi114 view_finance'[Start Time] - __prev )