FIFO， to count how long the inventory/stock pending days in warehouse and average it

[Anonymous]

Hi

Below is my original table , i have this material in warehouse  by dept, until here i stuck hope can get help from you guys, really appreciate it.

Sample: i had purchased two times for this material in this warehouse 

Date	Material	Warehouse	Department ID	Attribute	Value
02-Jan-20	M1	W1	Dep1	Stock In	4000
03-Jan-20	M1	W1	Dep1	Stock In	2500

Then i sold these item (total 5023 had been sold)

02-Jan-20	M1	W1	Dep1	Stock Out.1	279
03-Jan-20	M1	W1	Dep1	Stock Out.1	226
04-Jan-20	M1	W1	Dep1	Stock Out.1	296
06-Jan-20	M1	W1	Dep1	Stock Out.1	287
07-Jan-20	M1	W1	Dep1	Stock Out.1	227
08-Jan-20	M1	W1	Dep1	Stock Out.1	164
09-Jan-20	M1	W1	Dep1	Stock Out.1	143
10-Jan-20	M1	W1	Dep1	Stock Out.1	129
11-Jan-20	M1	W1	Dep1	Stock Out.1	183
13-Jan-20	M1	W1	Dep1	Stock Out.1	293
14-Jan-20	M1	W1	Dep1	Stock Out.1	208
15-Jan-20	M1	W1	Dep1	Stock Out.1	171
16-Jan-20	M1	W1	Dep1	Stock Out.1	150
17-Jan-20	M1	W1	Dep1	Stock Out.1	165
18-Jan-20	M1	W1	Dep1	Stock Out.1	187
20-Jan-20	M1	W1	Dep1	Stock Out.1	214
21-Jan-20	M1	W1	Dep1	Stock Out.1	217
22-Jan-20	M1	W1	Dep1	Stock Out.1	120
23-Jan-20	M1	W1	Dep1	Stock Out.1	196
24-Jan-20	M1	W1	Dep1	Stock Out.1	277
27-Jan-20	M1	W1	Dep1	Stock Out.1	314
28-Jan-20	M1	W1	Dep1	Stock Out.1	163
29-Jan-20	M1	W1	Dep1	Stock Out.1	106
30-Jan-20	M1	W1	Dep1	Stock Out.1	184
31-Jan-20	M1	W1	Dep1	Stock Out.1	124

I hope can according the sold quantity then identity the purchase based on FIFO method like result below:

Original Table 

[some_bih]

Hi @Anonymous check https://radacad.com/dax-inventory-or-stock-valuation-using-fifo hope this help