Create dax column for day shifts

[Anonymous]

I have a time column and want to create a column for 3 shifts:

Morning -> between 07:31:00 AM and 15:30:00 PM

Afternoon -> between 15:31:00 PM and 23:30:00 PM

Night -> between 23:31:00 PM and 07:30:00 AM

I made de following DAX code for a shifts column:

shifts =

SWITCH(

TRUE(),

TIMEVALUE('Tabel'[Time]) >= TIME(23,30,0),"Night",

TIMEVALUE('Tabel'[Time]) >= TIME(15,30,0), "Afternoon",

TIMEVALUE('Tabel'[Time]) >= TIME(7,30,0), "Morning"

)

I got 4 values in de shift column with :

Can somebody explain why i am getting blank ?

Thank you in advance.

[CNENFRNL]

Why don't you check it by yourself? 

[amitchandak · Accepted solution]

@Anonymous , Try like

shifts =
SWITCH(
TRUE(),
TIMEVALUE('Tabel'[Time]) >= TIME(23,30,0),"Night",
TIMEVALUE('Tabel'[Time]) >= TIME(15,30,0), "Afternoon",
TIMEVALUE('Tabel'[Time]) >= TIME(7,30,0), "Morning"
TIMEVALUE('Tabel'[Time]) < TIME(7,30,0), "Night"
)