Error Cannot compare Date with List

[Fa1con74]

Good morning,
I want to create a filter on dates, status and event name.
I do my filter on my "Building" table in which I have 3 virtual columns "EventStart, EventEnd, EventStatus" which are data from my "Events" table.
And I don't understand the mistake

isnotblank(Any(Select(Filter Building Master[Row ID],And([_Thisrow].[EventStart]>=Filter Building Master[Start Date]),[_THISROW].[EventEnd]<=Filter Building Master[End Date],[_THISROW].[EventStatus]=Filter Building Master[Status],[_THISROW].[Event]=Filter Building Master[Event],[_THISROW].[Class Bat]=Filter Building Master[ColorClass])))

[TeeSee1]

---

@Fa1con74 wrote:

[_Thisrow].[EventStart]>=Filter Building Master[Start Date]

---

The very first thing I noticed. This tries to compare a single value against a list, which does not make sense.

I see similar patterns all over your expression and certainly they need to be fixed.

Cannot be more specific without knowing the exact definitions of your tables.

[Fa1con74 · Accepted solution]

Thank you, indeed, so completely revised my approach and I achieved what I wanted
I close the ticket, thank you all