Hi @pravdon1, thank you for checking and additional notes.
Sorry I was stuck with my new project (just started) and get out of time.
I manage to update Cumulative weight(t) columns as you mentioned in the previous post and add Indicator Inventory Entry Type
1- BUY
2- SELL
3- SWITH (First BUY after SWITCH)
Also add a cumulative columns with reset at switch. It need additional updates, but I am posting as it is.
I put new measures in folder New Additional Inventory Measures
PBIX file:
Perpetual AVCO Inventory valuation using DAX example for pravdon3.0_WIP.pbix (373.6 KB)