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! Go to Solution.
Thank you, indeed, so completely revised my approach and I achieved what I wanted
I close the ticket, thank you all
User | Count |
---|---|
25 | |
15 | |
4 | |
3 | |
3 |