How to categorize the time values into different categories

Hi Anonymous ,

Please try below steps:

1. below is my test table

Table:

2. create a new column with below dax formula

Time_category =
VAR cur_time = [Time]
VAR _category =
    SWITCH (
        TRUE (),
        cur_time >= TIME ( 6, 0, 0 )
            && cur_time < TIME ( 11, 59, 59 ), "Breakfast",
        cur_time >= TIME ( 12, 0, 0 )
            && cur_time < TIME ( 15, 59, 59 ), "Lunch",
        cur_time >= TIME ( 16, 0, 0 )
            && cur_time < TIME ( 19, 59, 59 ), "Evening Snacks",
        cur_time >= TIME ( 20, 0, 0 )
            && cur_time < TIME ( 23, 59, 59 ), "Dinner",
        cur_time >= TIME ( 0, 1, 0 )
            && cur_time < TIME ( 5, 59, 59 ), "Midnight Craving"
    )
RETURN
    _category

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.