DAX with Today (text data type), Last 7 dates(with text data type) and future dates(date data type)?

Hi  Anonymous ,

I created some data:

Are you referring to the selection of the slicer to display the corresponding date.

Table1：

Table2：

Here are the steps you can follow：

1. Create measure.

Flag =
var _select=SELECTEDVALUE('Table'[Slicer])
var _today=TODAY()
return
SWITCH(
    TRUE(),
    _select="Today"&&MAX('Table 2'[Date])=_today,1,
    _select="Last 7 dates"&&MAX('Table 2'[Date])>=_today-7&&MAX('Table 2'[Date])<_today,1,
    _select="future dates"&&MAX('Table 2'[Date])>_today,1,0)

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

3. Result:

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