2 Replies Latest reply: Feb 28, 2018 4:05 AM by Pablo Labbe RSS

    Show Dimension of Latest Date

    Shok Yong

      Hi All,

       

      I have a issue where I have below sample data:

       

      Date             |     Name

      -----------------------------------

      20180101     |     Richard

      20180201     |     Emily

       

      Where I want to show column Name with latest Date (20180201), like below output

       

      Date             |     Name

      -----------------------------------

      20180201     |     Emily

       

      I have try below method:

       

      =IF(TEXT(COUNT({$<Date_Dup={$(=num#(date(max([Date.autoCalendar.YearMonth]),'YYYYMMDD')))}>}SEQ))='1',Name)

       

      * Date_Dup data type is general, is duplicate date I create based on Date field

       

      However the output I gain is

      Capture.PNG

      Which the field I created is a measure.

       

      What I want is it only show latest records only.

      Capture.PNG