May 25 2022 12:44 AM - edited May 25 2022 12:57 AM
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 inventory | Inventory changes | New inventory | Date |
1 | 20 | -5 | 15 | 01.01.19 |
2 | 5 | -3 | 2 | 01.01.19 |
1 | 15 | -3 | 12 | 01.01.19 |
1 | 12 | -2 | 10 | 01.01.19 |
1 | 10 | -5 | 5 | 31.10.19 |
1 | 5 | -5 | 0 | 31.10.19 |
2 | 2 | -5 | -3 | 01.11.19 |
And so on.
Many Thanks in advance.
May 25 2022 01:23 AM
@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.