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

    formula on dates

    jean-baptiste monteil



      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.