Show Next Milestone view

[dr_suresh_baabu]

Hello All,

I'm working on a requirement to display the next immediate milestone in a chart for all projects.

The following are my challenges that needs to be addressed while displaying the next milestone.  

1. My date is field is not sorted at source. 

2. The next milestone will not always be the following month. It can be any upcoming month

3.  A Project can have one or more milestone for the upcoming month .

In my attached sample data. I need to only show the one highlighted in RED. 

Could you please share your thoughts?

Thanks,

Suresh

[chrismarlow]

Hi,

Taking the liberty of changing your months into dates & just taking the first 7 rows of your data, you could use the following as an expression (& then hide it);

if(min(TOTAL <Project_ID> {<[Milestone Date]={">=$(=MonthStart(Today()))"}>}[Milestone Date])=[Milestone Date],1,Null())

As below;

You can do this with the dates not being held as dates, it is just a bit fiddly (in my opinion).

Cheers,

Chris.