Forum Discussion
Nested If problem with hours columns
Hello everyone, i'm having a little trouble with this If statement, where i'm trying to check by the "EndHour" if its "Morning" or "Evening" shift. Everything works perfectly from this point: = T...
Anonymous , Based on what I got, change as per need
Table.AddColumn(#"Renamed Columns1", "Shift", each if [Hora_Salida] <> null and [Hora_Salida] <= Time.FromText ("4:30:00 PM") then "Matutino" else "Vespertino" )