At the moment I’m having an issue for something that “should not” be very difficult.
I have a table with the records of employees [Employees].
Here I upload the information like “Task” daily, and this “Task” have an “Start Date” and “Finish Date”.
I want that when I will more information about any employee if he is working in any “Task” this row will appear as “Bussy”.
What I have done so far is:
FILTER(“Employee”, and([Employee] = [_THISROW].[Employee],
[Start date]<today(),[Start Date]>today()))
I suspect that my error is in “[Employee] = [_THISROW].[Employee]” but I’m doing this because I want to filter the actual Employee in this hole table.
Please let me know if you need more information.
PD: My error is that ALWAYS show it as “Available”