Forum Discussion

jsteffe's avatar
jsteffe
Icon for Helper III rankHelper III
3 years ago
Solved

Date period filter

Hello,   I manage animal movements in buildings. I get this table MOVEMENT : ID_movement, entry_date (in the building), exit_date (of the building), number of animals, building_id   When I choos...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi jsteffe ,

    According to your description, here's my solution.

    Create a measure:

    Measure =
IF (
    MAX ( 'Table'[start date] ) <= SELECTEDVALUE ( 'Date'[Date] )
        && COALESCE ( MAX ( 'Table'[end date] ), TODAY () )
            >= SELECTEDVALUE ( 'Date'[Date] ),
    1,
    0
)

    Put the measure in the visual level filter and select "is 1".

    After apply filter, get the correct result:

    I attach my sample below for your reference.

     

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi jsteffe ,

According to your description, here's my solution.

Create a measure:

Measure =
IF (
    MAX ( 'Table'[start date] ) <= SELECTEDVALUE ( 'Date'[Date] )
        && COALESCE ( MAX ( 'Table'[end date] ), TODAY () )
            >= SELECTEDVALUE ( 'Date'[Date] ),
    1,
    0
)

Put the measure in the visual level filter and select "is 1".

After apply filter, get the correct result:

I attach my sample below for your reference.

 

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.