Forum Discussion

Sharksguts's avatar
Sharksguts
Frequent Visitor
8 years ago
Solved

Inventory running total

I am trying to replicate the ERP stock transactional history table and then want to visualize it in a graph.   So we have the current stock level and the inventory transaction history.   I would ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi Sharksguts

    Create an index column from 0 in query editor.

    Then create two calculated columns

    Column1 = CALCULATE(SUM(Sheet1[TotalQty]),FILTER(ALL(Sheet1),[Index]<EARLIER([Index])))
    Column2 = [OnhandQty]-[Column1]

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Sharksguts

Create an index column from 0 in query editor.

Then create two calculated columns

Column1 = CALCULATE(SUM(Sheet1[TotalQty]),FILTER(ALL(Sheet1),[Index]<EARLIER([Index])))
Column2 = [OnhandQty]-[Column1]

 

Best Regards

Maggie