Creating a custom date range based on a given date input

Hi anthonydiclemen ,

According to your description, I create a sample.

Here's my solution.

1.Create a new Date table, don't make relationship between the two tables.

Date = VALUES('Table'[Date])

2.Create a measure.

Check =
IF (
    ISFILTERED ( 'Date'[Date] ),
    IF (
        MAX ( 'Table'[Date] )
            IN DATESINPERIOD ( 'Date'[Date], SELECTEDVALUE ( 'Date'[Date] ), -6, MONTH ),
        1
    ),
    1
)

Put the measure in the visual filter and select its value to 1, then put the new Date column in the slicer, get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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