topic Re: Need help with Daily Resource Loading for Production Elements (DAX to calculate load per day) in DAX Commands and Tips

Need help with Daily Resource Loading for Production Elements (DAX to calculate load per day)

nick_SMTC — Wed, 21 Apr 2021 15:27:28 GMT

Hello,

From our ERP system I have data on:
[Resource Name] (Machine Centre)
[Project Name]
[Start Date]
[End Date]
# of [Hrs of Work] required

I am trying to make a stacked bar chart that shows each day, with a slicer to filter per [Resource Name], showing which projects are being processed on on the days shown.

Right now I can make a stacked bar with all of the work showing up on the [End Date], but what I need to do is divide the [Hours of work] between the [start date] and the [end date], thus showing how much work is to be done on each project per day.

Thanks,

Re: Need help with Daily Resource Loading for Production Elements (DAX to calculate load per day)

amitchandak — Wed, 21 Apr 2021 16:02:25 GMT

nick_SMTC , refer if the blog or my file on similar topic attached after signature can help

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785

Re: Need help with Daily Resource Loading for Production Elements (DAX to calculate load per day)

nick_SMTC — Thu, 22 Apr 2021 00:11:21 GMT

Thanks amitchandak, got the date table working but having trouble with the formulas to assign a volume of work per date. Will continue to work on.

Re: Need help with Daily Resource Loading for Production Elements (DAX to calculate load per day)

nick_SMTC — Fri, 23 Apr 2021 00:14:35 GMT

Thanks amitchandak,

I was able to get the solution to work with some fine tuning. Top graph is what I had before and bottom graph is what I was able to cut it into in terms of daily resource use. Much appreciated!!