4 Replies Latest reply on Dec 7, 2017 7:38 AM by Mark Schukas

    max month and year from Date Measure

    Mark Schukas

      I have a column of dates in Excel (Date) mm.dd.yyyy

       

      the next column is a value (let's call it B)

       

      I would like to only display the most recent month and year (I might have a number of historical years in the data) in the form of:

       

      B's Value:       let's say:     99

      latest date:      let's say:  Dec 2017

       

      in the form of:      99

                             Dec 2017

       

      -two rows

      -above one another

      -month in mmm yyyy form\

       

      ?what expression do I use to the latest month of the latest year in the form:  mmm yyyy ?

       

      thank you.