Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Distribute a value across a time span.

Hi,

first time here and looking for some guidence. 

I have a Task, and that task is assigned to a Resource. The resource has a Duration to complete that task. The Duration has a Start Date and End Date The resource also has a set amount of Effort Remaining in which to complete that task.

So I have TASK, RESOURCE, DURATION and EFFORT REMAINING,START DATE, END DATE.

I already have a HRS PER DAY Value for the EFFORT REMAINING to be distibuted to the DURATION. 

 

 

I also have another Table 

In that Table I have the RESOURCE (DATAVERSE_ID). A DATE and a Capacity .

 

I'm trying to figure out how to distribute the hrs per day that are applicable to the duration dates and match those per day sums to the Capacity that a Dataverse_ID has on a particular day. I know that I need a measure to calculate all of this or perhaps some Calculated colum. Just a bit stumped at where to begin. So as I said at the begining, some guidence would be much appreciated.

 

Thanks

ImtiazA

 

 

 

2 Replies