Forum Discussion

nick_SMTC's avatar
nick_SMTC
Frequent Visitor
5 years ago
Solved

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...
DAX
Gantt
Load Graphs
Rate of Production
recursive
Resource Use
  • nick_SMTC's avatar
    nick_SMTC
    Frequent Visitor
    5 years ago

    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. 

  • nick_SMTC's avatar
    nick_SMTC
    Frequent Visitor
    5 years ago

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