How to create an hour/minute range filter?

[jonathangsanto]

Hi all,

I have a table with several times

GOAL: I need to create a start and end filter by time, filtering this table

What I've done so far:
I created a table that separates the time of a day from 15 to 15 minutes. 00:00 to 23:45

I want to select the start time and end time, and then it will filter the table within that range. In the example above it would be from 01:00 to 01:15
So the result should be:

I created a filter creating a condition, but I feel like I'm still far away:

var _rangeStart= TIME(00,00,00)

var _rangeEnd= SELECTEDVALUE(RangeTempo[HoraMinuto])

return

if(

SELECTEDVALUE(BH_gold_base[HoraMinuto])>=_rangeStart

&&

SELECTEDVALUE(BH_gold_base[HoraMinuto])<=_rangeEnd,

1)

Can anyone help me?

[Syndicate_Admin]

Can you attach an example?

[jonathangsanto]

worked perfectly! Thank you very much

[amitchandak · Accepted solution]

@jonathangsanto , Create two independent table with these time slots and the try a measure like

new measure =
var _max = maxx(allselected(Time2),Time2[Time])
var _min = minx(allselected(Time1),Time1[Time])
return
calculate( Count(Table[Time]), filter('Table', 'Table'[Time] >=_min && 'Table'[Time] <=_max))