Forum Discussion
Count Product Created from Remaining Inventory
Hello,
I have a table which is below:
| Product | Raw Material | Units Required to Create Product | Available Inventory |
| ABC | A | 1 | 456 |
| ABC | B | 2 | 22 |
| ABC | C | 1 | 334 |
| DEF | D | 1 | 677 |
| DEF | E | 1 | 24 |
| DEF | F | 1 | 45 |
This table shows Raw material required to create each product. Units shows quantity of raw material required required to create specific product while inventory column shows inventory.
I want to calculate the total products that can be created based on available inventory. It would be kep in mind each product require different quantity of raw materiak for creation. My outcome would be a below picture
| Product | Created Products |
| ABC | 11 |
| DEF | 24 |
Your help would be highly appreaciated.
Thank you
Hi Junaid11 ,
If I understand your request your outcome will be this:If you would please use this measure:
Number of Products Constrained = var _Product = MAX(Constraints[Product]) var _calc = CALCULATE(MIN(Constraints[Count per Raw Material]), FILTER(All(Constraints),Constraints[Product]=_Product)) Return _calcAfter you create a column in Power Query that adds a column which shows the maximum number of units that can be built after being constrained by the raw material input. Classic economics!
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
1 Reply
Hi Junaid11 ,
If I understand your request your outcome will be this:If you would please use this measure:
Number of Products Constrained = var _Product = MAX(Constraints[Product]) var _calc = CALCULATE(MIN(Constraints[Count per Raw Material]), FILTER(All(Constraints),Constraints[Product]=_Product)) Return _calcAfter you create a column in Power Query that adds a column which shows the maximum number of units that can be built after being constrained by the raw material input. Classic economics!
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel