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

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.

Try:

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

Thanks. Worked. Owe you a beer. :beer:

1 Like