Inventory . Replenish Stock

[sochoa]

Hello,

I have a little issue. I have already calculated how many products I need in order to replenish each products to the shop so as to reach 6 months of sales - stock. The topic is that I know how many products, but I would like to define how many Pallets I need and set which one of them. (Old one are priorized above the new ones) . Each pallets has different amounts of product and different number. How can I define how many and which ones pallets should I take in order to replenish those products?

I add the dashboard,

https://drive.google.com/file/d/1JXODOfQ95O0x67ktDL3ynTFCxAHBGjG1/view?usp=sharing

I will wait for your answer

Best regards,

Sebastian

[lbendlin · Accepted solution]

Power BI is a reporting tool, not an inventory management tool.  Use a tool that was designed for the job.

[lbendlin · Accepted solution]

Use SUMMARIZE or SUMMARIZECOLUMNS to collect all scenarios, calculate the measure for each of them, and then tally up the result.

[sochoa · Accepted solution]

I have never use summarize and summarizecolumns. I do not know how it would work.would you help me , and would you face this problem ? I'm really going to appreciate it

[sochoa]

Wonderful !!

[sochoa]

Good afternoon 

May I calculate how many of those are painted in green or I would not be able to calculate it? 

Best regards,

Please let me know if you know how I could do it

[lbendlin]

You need to materialize the measure before you can count that.

[sochoa]

I m sorry, I do not understand. How can I "materialize" the measure ?

[lbendlin · Accepted solution]

Use SUMMARIZE or SUMMARIZECOLUMNS to collect all scenarios, calculate the measure for each of them, and then tally up the result.

[sochoa · Accepted solution]

I have never use summarize and summarizecolumns. I do not know how it would work.would you help me , and would you face this problem ? I'm really going to appreciate it

[lbendlin · Accepted solution]

please look at the file I included.

[lbendlin · Accepted solution]

Power BI is a reporting tool, not an inventory management tool.  Use a tool that was designed for the job.