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...
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.
samdthompson
Memorable Member
Memorable MemberHello, 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 !!