Show only last value without duplicates

[Analitika]

I have Table1

OpNr  | ApNr | Sum | Date

123 | 456 | 300 | 2019-07-17
123 | 856 | 50 | 2019-08-07

Expected result

TotalSumByOpNr | MaxDate

350 | 2019-08-07

Total | 350 | empty (show no dates)

[amitchandak]

@Analitika ,

lastnonblankvalue(Table[Date], Sum(Table[Sum]))
max(Table[Date])

or

calculate(lastnonblankvalue(Table[Date], Sum(Table[Sum])), allexcept(Table[OpNr]))
calculate(max(Table[Date]), allexcept(Table[OpNr]))

to avoid GT

if(isfiltered(Table[OprNo]), max(Table[Date]), blank())

[Analitika]

no one example does no work at all

[az38 · Accepted solution]

@Analitika 

you can do it eaisly in visualization pane set as Sum aggregate for Sum field and max for Date field