Forum Discussion
Solved
Temporary Virtual Table based on Slicer
Have Table1 that includes columns: EmplId, ReportedDate, TimeReported, ProjectId, Activity. Table2 that includes columns: EmplId, ProjectId, AssignmentStartDate, AssignmentEndDate. Table3 has columns...
Hi Skykingcljr
The attached pbix is maybe what you're looking for... or not.
Please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.
Use slicers for Customer (from Table3) and ReportedDate (from Table1).
Identify EmplIds from Table2 where:
Their ProjectId maps to the selected Customer.
Their assignment dates overlap with the selected ReportedDate range.
Return all Table1 records for those EmplIds, even if the record’s ProjectId is blank or unrelated.