dividir mi hora en 3 turnos

[maria_fernanda]

Hola comunidad terngo un problema.
tengo una columna de hora y eso lo necesito poner en 3 turnos
turno uno es de 7:00am a 3:00pm
turno dos es de 3:00pm a 10:00pm
turno tres es de 10:00pm a 7:00am
podrían ayudarme cvon la condificon o orientarme como es porfvor

[Ahmedx · Accepted solution]

pls try this

[jmarciogsousa]

Turno = 
if(

    [hour] >= "07:00" && [hour] < "15:00", "turno 1",
    if([hour] >= "15:00" && [hour] < "22:00", "turno 2",
    if([hour] >= "22:00" && [hour] < "07:00", "turno 3",BLANK()
)))

[Ahmedx · Accepted solution]

pls try this

[maria_fernanda]

ESTA ES LA SOLUCION CORRECTA YA VALIDE LA INFOMACION Y ES CORRECTA MUCHAS GRACIAS 

[v-junyant-msft · Accepted solution]

Hi @Ahmedx @maria_fernanda ,

@Ahmedx The DAX side you provided seems to be misspelled here:

It should be 

TIME(23,59,59)

?

Best Regards,
Dino Tao 

[maria_fernanda]

MUCHAS GRACIAS DE ECHO ERA ESE PROBLEMA 

[maria_fernanda]

por que en el horaro de las 11 no me toma ningun turno ?

[Ahmedx]

Share sample pbix file to help you.

[jmarciogsousa]

Try, create new column

Turno = 
if(

    [hour] >= "07:00" && [hour] < "15:00", "turno 1",
    [hour] >= "15:00" && [hour] < "22:00", "turno 2",
    [hour] >= "22:00" && [hour] < "07:00", "turno 3",BLANK()
)

[maria_fernanda]

me aparece este error 

[jmarciogsousa]

Turno = 
if(

    [hour] >= "07:00" && [hour] < "15:00", "turno 1",
    if([hour] >= "15:00" && [hour] < "22:00", "turno 2",
    if([hour] >= "22:00" && [hour] < "07:00", "turno 3",BLANK()
)))