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
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.