I am trying to get ony the last value of costing date

[jhona1737]

Hi guys,

I am trying to get only the last value of the last costing date, could someone help me:

I was using somehting like this but is not workint

max(aggr(only([Costing date]),AvgCost,[Item number],Facility))

Thank you All

[dwforest]

max(aggr(max([Costing date]),AvgCost,[Item number],Facility))
this breaks down the max based on AvgCost,[Item number],Facility, but a max of max would really end up to be Max([Costing date]); may need more of an example of where this is to be used

[jhona1737]

I just would like to show to the end user only the last updated cost as example $0.94 

[dwforest]

Only({<[Costing date]={"=Max([Costing date])"}>} [Avg Cost])