Error Cannot compare Date with List

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])))

Solved Solved
0 2 425
1 ACCEPTED SOLUTION

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

View solution in original post

2 REPLIES 2
Top Labels in this Space