Calculating Employee capacity for the month based on weekly capacity / Working days in the month

[SioSho]

Hi All!

I need to calculate (via a measure so its dynamic) how many hours an employee has available to work in any given month, so i can then divide it by their actual hours/Budgeted hours, to get a % of available hours usage. by month (or date range if that possible!)

So i have a few tables this will apply to:

Budgeted time: So i can get the total % of budgeted hours based on that employees capacity

Actual time: So i can get an actual time usage.
Info table = "Weekly capacity", this also has a daily capacity columns, so we could use working days in the month instead to make it easier.

As working days in each month change, and we tend to look at our data on a month by month basis, is there a way to calculate this capacity in a way it will only calculate by working days? where the calculation can recognise the working days and x it by the daily capacity?

any help would be welcomed, many thanks!

 

[Matt Allington]

This article I wrote should help you. It seems similar to me.

Calculating Elapsed Business Hours Using DAX Part 2

I have learnt a lot over my 50 something years in life, and one of my greatest learnings is that “it doesn’t matter how much you already know, there is still more to learn”. Hopefully this is one of the reasons you read my blog – because you want to [...]Read More »

exceleratorbi.com.au