6 Replies Latest reply: Apr 17, 2015 11:33 AM by Jeff Held RSS

    Writing an Expression that Limits results based on max Year and Max Date

      I'm seeking help in writing an expression that will limit the results based on the max value date in two separate columns.  The first column is a Fiscal Year (2014, 2013, 2012...) and the second column contains a Date (10/31/2014, 11/30/2014, 12/31/2014). 

       

      What I currently have returns results for the max Fiscal Year:

       

      Sum({$<"Fiscal Year"={$(=max("Fiscal Year"))}>}[Adjusted Fair Value])

       

      I'd like to add in the max Date to this expression, but not clear on the syntax.  Any help would be appreciated.