Show up/Hide data depending on Specific date

Greg_Deckler , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:

Hi  Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Date =

CALENDAR(
    DATE(2024,1,1),DATE(2024,12,31))

2. Enter data – create a table.

3. Create measure.

Flag =
var _selectdate=SELECTEDVALUE('Date'[Date])
var _selectgroup=SELECTEDVALUE('Slicer_Table'[Slicer])
return
SWITCH(
    TRUE(),
    _selectgroup="before" && MAX('Table'[Enddate])<=_selectdate,1,
    _selectgroup="after" && MAX('Table'[Enddate])>_selectdate,1,0)

4. Place [Flag]in Filters, set is=1, apply filter.

5. Result:

Select before:

Select after:

Best Regards,

Liu Yang

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