cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Luiwujamak
Frequent Visitor

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:

 

= Table.AddColumn(#"Renamed Columns1", "Shift", each if [Hora_Salida] <= Time.FromText ("4:30:00 PM") then "Matutino" else "Vespertino" )

 

But i found that theres some records where the "EndHour" is "Null"  but i do not know how to use the nested if to check that if the "EndHour" is Null then to compare with the "StartHour" 

 

Will appreciate if anyone can help me with it

 

Luiwujamak_0-1674588044454.png

 

1 REPLY 1
amitchandak
Super User
Super User

@Luiwujamak , 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" )

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors