3 Replies Latest reply on Mar 1, 2018 3:09 AM by Yuriy Ovchinnikov

    Values on Last and Last(-1) Date of the data

    Yuriy Ovchinnikov

      Hi there!

      Please help, I'm trying to extract values on specific dates: latest and latest (-1).

      In the 1st place, I don't have problems with find what those dates are, i.e.:

      1) MAX([Date])

      and

      2) DATE(DATEADD('month',-1,MAX([Date])))

      calculations do the job.

       

      But I'm struggling to retrieve measure values (say, measure 'A') associated with these dates.

       

      (