Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add filter button for specific time range

Hello,     I want to add filter button to my report. Like this:   Between 07:05 - 15:20  Shift 1 Between 15:20 - 23-25 Shift 2 Between 23:35 - 07:05 Shift 3   Can you please help me? ...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    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

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , You can create a column  for that

first have time column or var in a column

 

Time = [datetime].Time
or
Time = Time(hour([datetime]),minute([datetime]),second([datetime]))

 

New bucket =

var _1  = Time(hour([datetime]),minute([datetime]),second([datetime]))

return

Switch( True(),

_1>= time(7,5,0)  && _1<= (15,20,0) , "Shift 1",

_1> (15,20,0)  && _1<= (23,25,0) , "Shift 2",

"Shift 3"

)

 

You can use that filter

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you for reply amitchandak 

     

    But I didn't understand how to do it. Can you help me with the attached file?

     

    https://easyupload.io/txugdw

     

    Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello   amitchandak

    This formul worked but it doesn't calculate minutes. How can i fix this.

     

    Vardiya =
    VAR hour =
    HOUR ( Z110_Lignes_pesee[Tartim_Bitis] )
    RETURN
    "Shift "& IF ( hour >= 7.30 && hour < 15.20, "Shift 1", IF ( hour >= 15.20 && hour < 23.35, "Shift 2", "Shift 3" ) )