Forum Discussion
Unsold Inventory Calculation
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
Really need to see example/sample data here.
I cleaned and manipulated the data into one table. So for each 4 WE Period I need to calculate the Shipping Units minus the balance from the previous Period. In this example the inventory Units for 4 W/E 01/27/18 is the Shipping Units (91,076) minus the Consumption Units (243.24) or 90,832.76. The next period Inventory Units results for 4 WE 02/24/18 would be the results from the prior period (90,832.76) plus the shipping from Period 4 WE 02/24/18 (138,620.00) minus the Consumption for Period (4 W/E 02/24/18 (5,681.57) which would be 223,771.60. This calc would repeat each month. Thoughts on how to structure the Inventory Units calculation?
A follow up...I have added the date into the table to go along with the "Period" perhaps this helps any calculation(s).
Thoughts?