Relative Date Filter based on Second Date

Hello, I am trying to filter one date off of another. I need to determine how many people were given both rx1 & rx2 in the same month, using rx2_date as a slicer. Here is some sample data: ...

Need Help

Anonymous

4 years ago

Hi IDepi22 ,

Please check this measure:

Measure =
CALCULATE (
    COUNT ( 'Table'[id] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        YEAR ( 'Table'[rx1_date] ) = YEAR ( 'Table'[rx2_date] )
            && MONTH ( 'Table'[rx1_date] ) = MONTH ( 'Table'[rx2_date] )
    )
)

Best Regards,

Jay

Forum Discussion

Relative Date Filter based on Second Date

Related content

Time Relative filter

Relative date filters resetting

Relative Date Filter suddenly stopped working

Date filter - Relative Dates

Filter Relative date