cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lpalacios Frequent Visitor
Frequent Visitor

Last Value per material and per date

Hello. 

I am quite new at Power Bi.

 

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

 

PlantPurchas. DocReleasind DateMaterialQtyAmount in USD
A1003000002530201610140000000000000000011,0030,00
A1003000002530201611240000000000000000011,0030,00
A3003000002896201611230000000000000000014,0089,00
    6,00149,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?