Add filter button for specific time range

[koray]

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?

Regards

[v-luwang-msft · Accepted solution]

Hi @koray ,

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

[koray]

Hello @v-luwang-msft 

Thank your for help 😘

[koray]

Who can help me?

[amitchandak]

@koray , 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

[koray]

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" ) )

[koray]

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.