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.