Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have dimensions ItemId, InventLocaionId, ValidateDate, InventBachId, how I can find MAX Transdate in expression, if I need MAX TransDate by InventBachId ?
Hi,
can you attach some data ?
you want to display max date on a column as expression or you want to filter with max date inside an expression ?
I want show it in column as expression.
so if your Transdate column is formatted as a date, you can simply use Max(Transdate), if not, use: Max(Date(Transdate))
Some data:
ItemId InventLocationId ValidateDate InventBachId TransDate
111 A 12/12/2017 X 10/12/2017
111 B 13/12/2017 X 11/12/2017
111 A 13/12/2017 X 12/12/2017
111 A 20/01/2018 Y 14/12/2017
I need to find:
ItemId InventLocationId InventBachId MaxTransDate
111 A X 12/12/2017
111 B X 12/12/2017
Excluding InventLocationId MAX TransDate of X is 12/12/2017
so try this:
=aggr(NODISTINCT Max(Date(TransDate)),InventBachId)
Thank you Youssef