How to Show Staff Capacity against Work by Month

[SteveMForm]

Fairly new to Power BI and DAX, I have got stuck with trying to calculate staff capacity to do work.

I have a Fact table where work = items, with each item having a start and end date and up to 7 resources with the capacity required for each (held as a decimal where Full Time Equivilant = 1.0) e.g. Resource Name 1, Capacity 1, Resource Name 2, Capacity 2 etc.

We have an organisation dimDates table which looks extensive enough, and I have inactive 1..* relationship from the dimDates table to the Start and End dates in the Fact table.

I know I'll need a measure(s?), but can't work out the DAX and am stuck.

I need to be able to sum up the total capacity on work for any given time and show a month by month view on a line and stacked column chart (my line comes from another table which is working which shows the average availability).

An additional bonus would be to then see by individual resource, and filter by another field (manager).

Thanks

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[SteveMForm · Accepted solution]

Re-posted here: How to show Staff Capacity against Work by Month - Microsoft Fabric Community

WIll close this one once you have given thumbs up

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[SteveMForm]

Hi there- sorry for delay- will post as a new thread as table column headers not being formatted