Last Value per material and per date

[lpalacios]

Hello. 

I am quite new at Power Bi.

I am working with database from SAP. I have a table like this one below

Plant	Purchas. Doc	Releasind Date	Material	Qty	Amount in USD
A100	3000002530	20161014	000000000000000001	1,00	30,00
A100	3000002530	20161124	000000000000000001	1,00	30,00
A300	3000002896	20161123	000000000000000001	4,00	89,00
				6,00	149,00

I want to have the SUM of Quantity and Amount in USD per Material and Per Plant.

eg.: Now the results i have is wrong and should be 5 instead of 6 for Qty

I realized that I have the same quantity for the material 1 twice, which I only need the value for the last realisaing date.

How can I solve it?