set analysis help

[Anonymous]

Hi i  have a table with 4 fields,

item,orderdate,unitcost,Rep

I want to get the unit cost for max(Orderdate).

I tried the following set expression ,it is not working .Please correct me

max({<OrderDate={$(=vDate)}>}[Unit Cost])

where vDate = max(OrderDate)

[Anonymous]

Sum({<OrderDate={"$(=vDate)"}>}[Unit Cost])

[PrashantSangle]

Hi,

Check date format after applying max()

OrderDate is num format then above solution work

else you need Date()

vDate=Date(max(OrderDate))

Regards

[ganeshreddy]

Hi RGV,

You can try both, Utkarsh and Max dreamer options. I hope it works fine

Best regards,

Ganesh