Forum Discussion

mmarshalek's avatar
mmarshalek
Frequent Visitor
8 years ago

Running total columns

Trying to create a shortage report in PowerBI

I have an origional balance of inventory and trying to provide a running total... 

Process is as follows:

  1. Inventory Balance - Demand + Purchase Orders = End Balance
  2. End Balance rolls to next day
  3. End Balance - Demand + Purchase Orders = End Balance
  4. Repeat #3

I'm lost on how to approach..  Could us advice...

Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    Can you post/sharesample data and will get you the solution?  Please mask any sensitive info

    • mmarshalek's avatar
      mmarshalek
      Frequent Visitor
      8 years ago

      Hi Parry2k,

       

      Thank you for guiding me on this below are screen shots of the 3 tables I'm using to develop this report...

       

      Inventory Table

      Demand Table

      Purchase Order Table

       

      Thanks again,

      Mike