Forum Discussion

sochoa's avatar
sochoa
Frequent Visitor
2 years ago
Solved

Inventory . Replenish Stock

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 kno...
  • lbendlin's avatar
    2 years ago

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

     

  • lbendlin's avatar
    lbendlin
    2 years ago

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

     

     

  • sochoa's avatar
    sochoa
    2 years ago

    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's avatar
    lbendlin
    2 years ago

    please look at the file I included.