topic Re: unit cost of the last product in DAX Commands and Tips

unit cost of the last product

Anonymous — Sat, 13 Aug 2022 16:39:23 GMT

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

Re: unit cost of the last product

technolog — Sun, 14 Aug 2022 11:41:39 GMT

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

Re: unit cost of the last product

Anonymous — Sun, 14 Aug 2022 13:45:22 GMT

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.

Re: unit cost of the last product

technolog — Sun, 14 Aug 2022 14:20:36 GMT

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

Re: unit cost of the last product

Anonymous — Sun, 14 Aug 2022 14:23:44 GMT

you are great, thank you.