load graphs
1 Topic
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,Solved1.3KViews0likes3Comments