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