Forum Discussion
Capture oldest date for the same item
Hi,
How to create a new date column if the material_storage has the same Date Extract then capture the oldest date for Date Received?
| Date Extract | Material_Storage | Date Received | Qty | New Date |
| 17-04-21 | 03-60787-03A_1001 | 05-10-20 | 2 | 05-10-20 |
| 17-04-21 | 03-60787-03A_1001 | 13-11-20 | 1 | 05-10-20 |
| 17-04-21 | 03-60787-03A_1001 | 20-01-21 | 1 | 05-10-20 |
| 10-04-21 | 03-60787-03A_1001 | 22-03-21 | 1 | 16-01-21 |
| 10-04-21 | 03-60787-03A_1001 | 16-01-21 | 2 | 16-01-21 |
Hello, try something like this:
OldestDate = CALCULATE(MINX(Table1,Table1[Date Received]), ALLEXCEPT(Table1,Table1[Date Extract]))You might need to play around with the table name to what ever your is.
2 Replies
Hello, try something like this:
OldestDate = CALCULATE(MINX(Table1,Table1[Date Received]), ALLEXCEPT(Table1,Table1[Date Extract]))You might need to play around with the table name to what ever your is.
Thanks samdthompson !!