Finding max Date given a criteria

[#1]

I have a list of dates and each of them is either TypeA or TypeB. I am trying to select the largest (or most recent) date from the list among only the TypeAs.

So far I have been using Date(Max ([X_Date])) but I have not been able to figure out how to select based on a criteria.

What I want is something like Date(Max ([X_Date]) where Category = {'TypeA'}).

Any advice on how this can be achieved?

[its_anandrjs]

Hi Dkeresteci,

Do you have any sample file it will going more easy.

Regards,

Anand

[#3 · Accepted solution]

Hi Dkeresteci,

In a chart you can use set analysis like:

Date(Max({$<Category={TypeA}>}[X_Date])

Regards,

Bert

[#4]

Awesome, works great, thanks Bert!