DAX Expression – How to determine Shift in “Shift” column based on Time in “Time” Column
Case statement CASEWHEN CONVERT(VARCHAR(8), datetime, 108) BETWEEN'07:00:00' AND '14:59:00' THEN 'Day'WHEN CONVERT(VARCHAR(8), datetime, 108) BETWEEN'15:00:00' AND '22:59:00' THEN 'Evening'ELSE 'Night'END AS ShiftName You can also use Switch statement WorkShift =…