Add filter button for specific time range

Hi Anonymous ,

Test the below dax to create a new column:

Vardiya = 
VAR hour =
    HOUR ( Sayfa1[Tartim_Bitis] )
VAR MINUTE =
    MINUTE ( Sayfa1[Tartim_Bitis] )
VAR test =
    FORMAT ( Sayfa1[Tartim_Bitis], "hh:mm:ss" )
RETURN
    IF (
        test >= "07:05:00"
            && test < "15:20:00",
        "Shift1",
        IF ( test >= "15:20:00" && test < "23:25:00", "Shift2", "Shift3" )
    )

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien