How find MAX date with were?

[irmantas]

Hi Folks,

I have Table like this:

ItemId     OperationDate     Qty     StatusReceipt     StatusIssue

XX          03/03/2017          1          Purch    

XX          05/03/2017          1                                   Sale

XX          06/03/2017          1          Ordered

How I can find ItemId firs date of Purch and Last date of Sale in Expression?

[sunny_talwar · Accepted solution]

May be this

Dimension

ItemId

First date of Purch

Min({<StatusReceipt = {'Purch'}>}OperationDate)

Last date of Sale

Max({<StatusIssue = {'Sale'}>}OperationDate)

[irmantas]

Thank you Sunny. it's works.