3 Replies Latest reply: Apr 20, 2015 5:05 PM by Ramon Covarrubias RSS

    Aggregating Values based on Max Date and Max Date -365

      I'm attempting to put together a financial statement that displays the current value based on the Max Date which is the quarter end date of 12/31/14.  I am using the following expression that is giving me the correct values:


      =Sum({$<[BS Date]={"$(=Date(Max([BS Date])))"}>}[Total Adjusted Fair Value])


      I need to add a column that displays the values for the quarter end date of the prior year, 12/31/13, with no luck.  Would adding -365 to the expression give me the prior year.  The data is tagged with a 12/31/13 end date.