I have a table called Workers and a table called TimeSheets (relevant to this question). To facilitate scheduling I have built a display that lists my workers in the first column and then a column for each day of the week.
To accomplish this, I used the Workers table and added a virtual column for each day extracted from a Slice of the selected week’s TimeSheets table, against each employee like:
[Monday]= SELECT(SelectedWeek[Job], AND(([Worker] = [_THISROW].[Worker]) , Weekday([Work Date])=2))
It works but only lists one entry per day because my Workers table only has each employee listed once. If an employee has two timesheet entries for one date (e.g. 7:00 – 13:00 at Job A and 13:00 -17:00 at Job B) then only one will display.
I can’t think of any way to do it, but I hoped someone in the community may think of a way.