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
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
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
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
