Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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
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()
)))
pls try this
ESTA ES LA SOLUCION CORRECTA YA VALIDE LA INFOMACION Y ES CORRECTA MUCHAS GRACIAS
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
MUCHAS GRACIAS DE ECHO ERA ESE PROBLEMA
por que en el horaro de las 11 no me toma ningun turno ?
Share sample pbix file to help you.
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()
)
me aparece este error
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() )))
User | Count |
---|---|
119 | |
65 | |
65 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |