Filter data by date range

[Anonymous]

I have some flow data from a stream and also a list of reservoir events (that have start and end dates). Say I click on Event 1 (start date 1/1/2011, end date 1/6/2011), how do I set up that relationship so that the it zooms to that date range whenever I click on an event? I can't seem to manage the relationship so that it goes to the entire range, instead it just goes to the start or end date.

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may create a date table and then create the measure like below.Attached sample file for your reference.

Date = CALENDARAUTO( )

Event = 
VAR currentDate =
    MAX ( 'Date'[Date] )
RETURN
    CALCULATE (
        MAX(Table1[Event]),
        FILTER (
            Table1,
            ( Table1[Start Date] <= currentDate
                && Table1[End Date] >= currentDate )
        )
    )

Regards,