Number of days with quantity greater than 0

New Contributor

Hi,
I am working on a function that consists of a table with entries on items, the changes in stock and new stock. I want to count every day, where the minimum of Inventory was greater than zero per Artice-No.
My problem is that, there is more than one entry per day, so I would first have to determine the minimum per day.
In addition, not every item has one entry per day and sometimes the Inventory is negative. 

My table looks like this.



Article-No.Old inventoryInventory changesNew inventoryDate
120-51501.01.19
25-3201.01.19
115-31201.01.19
112-21001.01.19
110-5531.10.19
15-5031.10.19
22-5-301.11.19
     

 

And so on. 

Many Thanks in advance. 

1 Reply

@Yonah_ Have not considered a formula solution as this can fairly easily be resolved with Power Query. A working example is in the attached workbook.

Riny_van_Eekelen_0-1653466981354.png