Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Sum({<OrderDate={"$(=vDate)"}>}[Unit Cost])
Hi,
Check date format after applying max()
OrderDate is num format then above solution work
else you need Date()
vDate=Date(max(OrderDate))
Regards
Hi RGV,
You can try both, Utkarsh and Max dreamer options. I hope it works fine
Best regards,
Ganesh