I have been trying to modify Sam’s budget allocation model. My basic scenario is that we have an estimated time in hours that we think it will take to complete a job and this time should be budgeted to be completed within a starting date and an end date. Following Sam;s model as best I can I have managed to get to the point where I can now calculated the Budgeted Job Time and The Budgeted Job Days (working days). that the time can be allocated over. I am wondering where I am going wrong with the Job Budget Time Allocation Measure as I ti only show a calculation for a single day rather than allocating this time of the number of days that the job will be done over.
My Measure looks like the following:
Job Budget Time Allocation =
VAR DayInContext = COUNTROWS(Dates)
VAR BudgetedJobDays = SUM(‘Job Budget’[Job Budget Days])
DIVIDE(DayInContext,BudgetedJobDays,0)*[Budgeted Job Time],0)
I have included a trimmed down version of my model that should help.
Thanks in Advance
DatesBetweenModel.pbix (187.4 KB)