How to group/summarize and sum the amount of the maximum date in DAX

[SeymaKalay]

I have a sample data as below. I would like toGroupBY Group1 and Group2 variables, SUM the amount and only keep the Max(Date) using DAX. Many thanks in advance.
Group1   Group2   Date            Amount
A1           B1         6\20\2025     3
A1           B1         6\20\2025     5
A1           B1         6\19\2025     7
A2           B2         6\20\2025     9
A2           B2         6\19\2025     11

Expected Answer
A1 B1 6\20\2025 8
A2 B2 6\20\2025 9

[SeymaKalay]

thanks a lot ❤️

[MFelix · Accepted solution]

Hi @SeymaKalay ,

For this you just need to crate 2 measures:

Date Max = MAX(Table[Date])

Sum Amount = 
var MaxDate = [Date Max]
Return
CALCULATE(
SUM(Table[Amount]),
Table[Date] = MaxDate)

In my example I have added another values so you can see it returns the correct results: