Forum Discussion

Hllt369's avatar
Hllt369
New Member
4 years ago
Solved

Filters between dates

Hi!   I want to know how create this in dropdown I know we can use the slicer and the between option but i want to use 2 different filters I have one date table if a choose...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Hllt369 , You need to use two table for that both are independent

     

    In second slicer you will use filter using this measure - not is blank

    countrows(Date2, Date2[Date] > maxx(allselected('Date1'), 'Date1'[Date] ) )

     

    this will restrict 2nd slicer

     

    Now using these two

     

    example measure from a table

     

    Date Range Using 2 slicer =
    var _max = minx(allselected(Date1), Date1[Date])
    var _min = maxx(allselected(Date2), Date2[Date])
    return
    calculate(countrows(Table), Filter(Table,(Table[Date] <=_max && Table[Date]) >=_min) )

     

     

     

    refer if needed

    How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg

amitchandak's avatar
amitchandak
Super User
4 years ago

Hllt369 , You need to use two table for that both are independent

 

In second slicer you will use filter using this measure - not is blank

countrows(Date2, Date2[Date] > maxx(allselected('Date1'), 'Date1'[Date] ) )

 

this will restrict 2nd slicer

 

Now using these two

 

example measure from a table

 

Date Range Using 2 slicer =
var _max = minx(allselected(Date1), Date1[Date])
var _min = maxx(allselected(Date2), Date2[Date])
return
calculate(countrows(Table), Filter(Table,(Table[Date] <=_max && Table[Date]) >=_min) )

 

 

 

refer if needed

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg