Forum Discussion

ThaddeusB's avatar
ThaddeusB
Helper I
7 years ago
Solved

Filter for active within time range

I have a set of data like (plus additional columns:   Client Entry Date Exit Date 205 3/24/2018 3/26/2018 206 12/9/2009 7/26/2017 207 11/10/2017 12/21/2017 208 10/29/2017 1...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    ThaddeusB

     

    try something on these lines

    See file attached as well

     

    Then you can use the MEASURE as a visual filter

     

    Measure =
COUNTROWS (
    FILTER (
        table1,
        Table1[Entry Date] >= MIN ( 'Calendar'[Date] )
            && Table1[Exit Date] <= MAX ( 'Calendar'[Date] )
    )
)

     

     

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

ThaddeusB

 

try something on these lines

See file attached as well

 

Then you can use the MEASURE as a visual filter

 

Measure =
COUNTROWS (
    FILTER (
        table1,
        Table1[Entry Date] >= MIN ( 'Calendar'[Date] )
            && Table1[Exit Date] <= MAX ( 'Calendar'[Date] )
    )
)