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.
Solved! Go to Solution.
Try:
IN(
TODAY(),
SELECT(
Racing Days[Racing Date],
AND(
ISNOTBLANK([Track Name]),
([Track Name] = [_THISROW].[Track Name])
)
)
)
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |