Forum Discussion
Project Task resource allocation table
This needs a little more work. You need a calendar dimension and a resource dimension. Then you can do a cross join and a measure that ties it all together. Feel free to add months and years etc to the calendar table.
Hi lbendlin , Just now realized that I missed one logic here. How can I make the allocation not to calculate when there's Saturday and Sundays? Is there a way in the date table that I can mark ignore the days (Weekends and Holidays. For Holidays, I can update them manually) so that the allocation doesnt fall in those days.
(I am getting all the date input from smartsheet and it auto adds Weekends when I enter the start date and duartion. So the data input is good and because of we use the allocation to full from start to end dates we are adding additional resources)
Thank you very much for your time!
In line 3 you can add a WEEKDAY() filter against the [Date] column.