0 Replies Latest reply on Jul 25, 2018 6:05 AM by jean-baptiste monteil

    formula on dates

    jean-baptiste monteil

      Hi,

       

      For an historical set, I'd like to show the last value of a measure, and the date associated. The problem is that my measures don't have the same last date.

      Then I want to show the values at: -  [last date]-one week

                                                             -  [last date]-one month

                                                             -  [last date]-three months

                                                             -  [last date]-six months

                                                             - [last date]-one year.

       

      Here attached are the goal file (target), the try file (my code), and a sample of my set of data.

       

      Any advice would be greatly appreciated.

       

      Thanks,

      Jean-Baptiste.