topic creating a timeslot column with dax in DAX Commands and Tips

creating a timeslot column with dax

lawada — Mon, 14 Dec 2020 07:38:31 GMT

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

Re: creating a timeslot column with dax

AlB — Mon, 14 Dec 2020 09:32:31 GMT

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