Data from the last Timeline for every Year

[marcoebner]

I have a list of hundreds of projects . Each project has many timelines . I need the latest timeline annually.

[JonnyPoole]

Perhaps change the dimension

from:   <Date>

To:    Aggr( Max( <Date>) , <Project>, <Year> )

You may need to change your load editor to include a Year field

load

     <Date>

from <>

->

load

     <Date>

     Year(<Date>) as Year

from <>

[marcoebner]

Good solution , thanks for the support