If Statement for Day and Time

[Anonymous]

Hello,

I am trying to build a statement for the below by shift , but with no luck. 

A: Sunday-Tuesday 6:00 am-6:00 pm, Wednesday 6:00 am-Noon = Green Days

B: Wednesday Noon-6:00 pm, Thursday-Saturday 6:00 am-6:00 pm = Yellow Days

C shift Sunday-Tuesday 6:00 pm-6:00 am, Wednesday 6:00 pm-12:00 am = Green Nights

D shift Wednesday 12:00 am-6:00 am, Thursday- Saturday 6:00 pm-6:00 am = Yellow Nights

if Date.DayOfWeek([END_DATE_TIME])=<3 and Time.Hour[END_DATE_TIME])>=6 and Time.Hour([END_DATE_TIME])<16 then "Green Day"

Your help is much appreciated. 

[VasTg · Accepted solution]

@Anonymous 

How is this post different from your existing post?

https://community.powerbi.com/t5/Desktop/IF-Statements-For-Date-and-Time/m-p/910976?search-action-id=99616540806&search-result-uid=910976

[Anonymous]

Hello,

I wanted to start a new thread since the original thread was solved on my original request. 

I am getting an error when trying to insert the dayofweek function. 

[amitchandak]

What is the issue you are getting? Can you share your table structure with sample data.

You can also try SWITCH, true

https://community.powerbi.com/t5/Desktop/Help-with-SWITCH-TRUE-with-multiple-items-to-evaluate/td-p/...