Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Dkeresteci,
In a chart you can use set analysis like:
Date(Max({$<Category={TypeA}>}[X_Date])
Regards,
Bert
Hi Dkeresteci,
Do you have any sample file it will going more easy.
Regards,
Anand
Hi Dkeresteci,
In a chart you can use set analysis like:
Date(Max({$<Category={TypeA}>}[X_Date])
Regards,
Bert
Awesome, works great, thanks Bert!