Forum Discussion

sc24's avatar
sc24
Frequent Visitor
8 years ago
Solved

is this possible?

I have a table that is similar to below:

start                    end

1/1/2000            1/1/2015

1/5/2005             1/5/2020

 

I am trying to use a slicer to set a date range. If the dates in the slicer fall in between the start/end columns, show the row.

So, a date range of 2/1/2001 - 2/1/2010 would show the first row and filter out the second.

 

 

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    sc24,

    Create the following measure in your table, then drag the measure to Visual level filters of your visual and set its value to 1.

    checkmeasure = IF(MAX(Table[start])<=MIN(DateTable[Date])&& MAX(Table[end])>=MAX(DateTable[Date]),1,0)



    Regards,
    Lydia

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    sc24,

    Create the following measure in your table, then drag the measure to Visual level filters of your visual and set its value to 1.

    checkmeasure = IF(MAX(Table[start])<=MIN(DateTable[Date])&& MAX(Table[end])>=MAX(DateTable[Date]),1,0)



    Regards,
    Lydia