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

[nick_SMTC]

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,  

[amitchandak · Accepted solution]

@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-o...

[nick_SMTC]

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!!

[nick_SMTC]

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.