Forum Discussion

vrossouw's avatar
vrossouw
Icon for Helper III rankHelper III
6 years ago

Accummulated total, but start from zero

Hi,  I have the below table, where the SOH Pre purchase is the running total of SOH start + Manufacture Qty - Units Sold. However, in some cases, we do not have stock and then have to purchase the ...
Need Help
vrossouw's avatar
vrossouw
Icon for Helper III rankHelper III
6 years ago

Hi, the problem is that the purchase quantity, is a calculated quantity.

For example if the shortfall in units are 9, such as in line 2, the 9 units must be purchased.

My problem is to add these additional 9 units then back into the running stock on hand quantity.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

vrossouw 

You are able to add the additional Purchase Quantity back to the running total by simple adding even it is calculated column.

I don't really get what do you mean, can you provide a sample pbix and show us the expected result in the columns.


Best,
Paul

  • vrossouw's avatar
    vrossouw
    Icon for Helper III rankHelper III
    6 years ago

    Hi, I have saved the excel file in this downloadable link.

     

    Excel file with workings 

     

    I try to recreate the below columns - highlighted in red on the file, in Power BI.

     Purchase Prev Buy check end soh 

     

    I appreciate your time.

     

    Regards

    • vrossouw's avatar
      vrossouw
      Icon for Helper III rankHelper III
      6 years ago

      Hi,  I have calculated the Purchase Qty outside of Power BI for now.