6 Replies Latest reply on Jan 13, 2017 1:29 PM by Jamieson Christian

    Show MAX for a measure based on date not included in view

    mark.welsh

      I never know if my titles make sense, but in the attached workbook I need to calculate the Max(BudgetYTD) for all of the months included in the "YTD CY" filter.  In the case for November that value would be (3,279,315.00) for Account7Dig 6080.10.  Really, I just need to bring in the BudgetYTD for the Max(DateTime) gathered form the filter. 

       

      I've been messing with LOD and index calcs forever, but I'm not getting anywhere.  Thanks for any help.