Slice (Filter Table) Based on Values in a Reference Table

[yastaaa]

I have two Tables Tracks {[Track Name], [Track Logo]} and Racing Days {Track Name], [Racing Date]}.

The intention is to show only the tracks that have a row with [Racing Date]= TODAY().

Tried many ways and no working.

I need to filter a slice based on the equalit... Questions

May I ask what is the result with your formula? It’s not working in what way?

[Steve · Accepted solution]

Try:

IN(
  TODAY(),
  SELECT(
    Racing Days[Racing Date],
    AND(
      ISNOTBLANK([Track Name]),
      ([Track Name] = [_THISROW].[Track Name])
    )
  )
)

[yastaaa]

Thanks. Worked. Owe you a beer.