creating a timeslot column with dax

[lawada]

i want to create a colomn that devides the hours through the day into three time slots 

8:00 AM- 4:00 PM 

4:00 PM - 12:AM

12:00 AM- 8:00 AM 

i have created the following calculated column : 

however im only getting two timeslots in my filter instead of getting all the three timeslots :

can someone help with this

[AlB · Accepted solution]

Hi @lawada 

You need an AND (&&) instead of an OR (||) in the condition checks. And in the second line you actually need only to check if HOUR is >= 16. The < 00 will not work

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers