unit cost of the last product

[Anonymous]

Hi

I want to calculate the cost of the product entered from the latest date. 

I want to get the unit amount from the latest date in the cost table. But I couldn't find how to find it with a formula.

new coast = CALCULATE([sum maliyet MMM],LASTDATE(coast_2019[InvoiceDate]))

It gives the category totals of the same products with this formula. I want to show the latest unit prices

Thank you

[Anonymous]

Thank you for the answer. It is an excellent feeling for us to have people who help in such a platform.

Itemcode P-000009076 code  as in the example, but an expression like 134,911,40 appears.

It should be 546.20. I think the Itemcode collects and writes its totals. Can you help me.

[technolog · Accepted solution]

I think that problem connected with several prices with one date. We can try use

latest price = 
VAR _LastDate = CALCULATE( MAX(coast_2019[InvoiceDate]), ALLEXCEPT(coast_2019, coast_2019[ItemCode]))
VAR _Result = CALCULATE( MAX(coast_2019[coast MMM]), FILTER(coast_2019, coast_2019[InvoiceDate] = _LastDate ))
RETURN
_Result

[Anonymous]

you are great, thank you.

[technolog]

Hi

latest price = 
VAR _lastDate = CALCULATE( MAX(coast_2019[InvoiceDate]), ALLEXCEPT(coast_2019, coast_2019[ItemCode]))
VAR _Result = CALCULATE( SUM(coast_2019[coast MMM]), FILTER(coast_2019, coast_2019[InvoiceDate] = _lastDate))
RETURN
_Result