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...
HotChilli
Community Champion
Community ChampionThis will give you a column with the previous end time so you can get the difference with a subtraction:
Add a custom column (sub in previous step for #"Changed Type")
let a = [Sched_Start] in List.Max(List.Select(#"Changed Type"[Sched_Finish], each _ <= a))it will be a little more complex with different employee ids
HotChilli TY. I need to have this in DAX rather than Query Editor.