Get latest date values

Hi RafaelAri ,

Thanks for all the replies!
And RafaelAri , I think rajendraongole1's reply is close, so I modified his response a bit:
Here is my sample data:

I changed his DAX into this:

Latest_Qty_With_Status_1 = 
VAR _RecentDate = 
CALCULATE(
    MAX('Table'[Status Date]),
    FILTER(
        ALL('Table'),
        RIGHT('Table'[Status], 2) = "\1" && 'Table'[Item] = MAX('Table'[Item])
    )
)
RETURN
CALCULATE(
    SUM('Table'[Qty.]),
    ALL('Table'),
    RIGHT('Table'[Status], 2) = "\1" && 'Table'[Item] = MAX('Table'[Item]) && 'Table'[Status Date] = _RecentDate
)

And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.