Forum Discussion
froxas
Helper II
Helper IImake workload scheduler
Hi, Here is production of furniture. I have in database operations. I can sum total hours needed to make orders for each operations. also i have resources availability per operation ped day. ...
froxasHelper II
Helper II
Fowmy
Super User
Super Userfroxas
You need to have a column in the Orders table for the date that will indicate when each activity took place. This way, you can create a calendar a link with the date to visual in a matrix.
You base measure needs to be modified as :
DaysPlanned =
ROUNDUP(
DIVIDE(
SUM(Orders[WorkScope]),
MAX(Operations[ResourcesInHoursPerDay])
),
0)________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply š