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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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

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

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

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

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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 PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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