Max date in expression

[irmantas]

Hello,

I have dimensions ItemId, InventLocaionId, ValidateDate, InventBachId, how I can find MAX Transdate in expression, if I need MAX TransDate by InventBachId ?

[YoussefBelloum]

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 ?

[irmantas]

I want show it in column as expression.

[YoussefBelloum]

so if your Transdate column is formatted as a date, you can simply use Max(Transdate), if not, use: Max(Date(Transdate))

[irmantas]

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

[YoussefBelloum · Accepted solution]

so try this:

=aggr(NODISTINCT Max(Date(TransDate)),InventBachId)

[irmantas]

Thank you Youssef