topic Re: How to Show Staff Capacity against Work by Month in DAX Commands and Tips

How to Show Staff Capacity against Work by Month

SteveMForm — Fri, 02 Feb 2024 11:14:19 GMT

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

Re: How to Show Staff Capacity against Work by Month

lbendlin — Sat, 03 Feb 2024 01:45:23 GMT

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-Forum/ba-p/963216

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/1447523

Re: How to Show Staff Capacity against Work by Month

lbendlin — Sat, 03 Feb 2024 02:01:06 GMT

Re: How to Show Staff Capacity against Work by Month

SteveMForm — Mon, 05 Feb 2024 08:54:24 GMT

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

Re: How to Show Staff Capacity against Work by Month

SteveMForm — Mon, 05 Feb 2024 11:36:35 GMT

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