HELP with DAX

Hi  dimidi ,

Here are the steps you can follow：

1. Select [Shift_Start] and [Shift_End] - Duplicate Column..

2. Select each of the two copied columns - Time - Time Only.

3. Create calculated table.

Time =
VAR __StartTime= TIME(0,0,0)
var __EndTime= TIME(23,0,0)
var __Duration= TIME(1,0,0)
return
GENERATESERIES(__StartTime,__EndTime,__Duration)

4. Create measure.

Time =
VAR __StartTime= TIME(0,0,0)
var __EndTime= TIME(23,0,0)
var __Duration= TIME(1,0,0)
return
GENERATESERIES(__StartTime,__EndTime,__Duration)

5. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly