Forum Discussion

jonathangsanto's avatar
jonathangsanto
Helper I
4 years ago
Solved

How to create an hour/minute range filter?

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?

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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