Forum Discussion
Need help with Daily Resource Loading for Production Elements (DAX to calculate load per day)
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,
3 Replies
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.
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!!
