Forum Discussion
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?
Regards
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 RegardsLucien
6 Replies
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 RegardsLucien
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
Thank you for reply amitchandak
But I didn't understand how to do it. Can you help me with the attached file?
Thank you.
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" ) )
