Forum Discussion

mscabrera's avatar
mscabrera
Icon for Helper I rankHelper I
3 years ago
Solved

Capacity and % of Occupancy

Hi everyone I've been having troubles to find a solution for this problem. I need to present in a report the capacity and the % of occupancy for a group of machines. To give you some context. There ...
Need Help
mscabrera's avatar
mscabrera
Icon for Helper I rankHelper I
3 years ago

I found a solution (partially) by using this post:

Solved: Number of active projects per month knowing start ... - Microsoft Power BI Community  Thanks Greg_Deckler 

   Open Tickets - Microsoft Power BI Community

 I have the part of the numer of projects, but still couldn't figure out how to divide that number of projects by the capacity of each machine ( I have a specific table for capacity of every machine for every week / day) but don't know how to integrate them and make ir work. Any ideas?

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    mscabrera Any chance you can provide some sample data? I can't picture what your data looks like in terms of the capacity of each machine.

    • mscabrera's avatar
      mscabrera
      Icon for Helper I rankHelper I
      3 years ago

      Hi Greg_Deckler thanks in advance for your reply

      Attached you could find the data PBIx and an excel file with the expected result. The On going Prod table, is the one that I already managed to do thanks to your post. The capacity available table is addresed in the pbi file and in the excel, and I have to mention that I fill the capacity every week, so I will connect the excel file to the model to update the disponibility/capacity for every Line-Machine (KeyToCapacity column). The expected result would be the table named Running Occupation Per Week that is in the excel file.

      Please let me know if there's anything to clarify

      Files: https://we.tl/t-h2jA9hQKz3