Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
nick_SMTC
Frequent Visitor

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,  

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

3 REPLIES 3
amitchandak
Super User
Super User

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

 

 

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_0-1619136856438.png

 

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. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors