Create a new measure, Cumulative Inventory, based on Sale In (SI) and Sale Out (SO) columns:
For January 2023, Cumulative Inventory = 0 (starting month for inventory calculation).
For months after January 2023, Cumulative Inventory = Previous month’s Cumulative Inventory + Previous month’s SI – Pre
//But its errors
New contributor
Đỗ Trung Thành is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.