Forum Discussion
Find First Positive AFTER first negative
I'm trying to create an inventory model that shows things we expect to go negative inventory on based on incoming purchase orders vs demand. I've been able to create a way to find the first date we g...
Please provide that sample data in usable form (not as a screenshot)
Does this work - can't seem to get a pbix file to work correctly. Looking for a way to return 7/14/2023 (first positive after first negative) and -2 max negative it went during that time period
| Part Number | Due Qty | Due Date | On Hand | Part Wise Running Total | Updated Running Total | Index | CheckStatus |
| B | -5 | 12/21/2022 | 7 | -5 | 2 | 9089 | Positive |
| B | -1 | 6/20/2023 | 7 | -6 | 1 | 9090 | Positive |
| B | -1 | 6/23/2023 | 7 | -7 | 0 | 9091 | Zero |
| B | -1 | 6/29/2023 | 7 | -8 | -1 | 9092 | Negative |
| B | -1 | 7/5/2023 | 7 | -9 | -2 | 9093 | Negative |
| B | 7 | 7/14/2023 | 7 | -2 | 5 | 9094 | Positive |
| B | -1 | 7/14/2023 | 7 | -3 | 4 | 9095 | Positive |