3 Replies Latest reply on Oct 15, 2018 9:43 AM by Tushar More

    Show Value Dynamically By Max Date Filter

    JEDIDIAH NIGRO

      I'm trying to show a value (we can call it sales) based on the max date that a user filters to. So the default value would be the current month, but as a user applies the date filter slider, the value displayed would only show the max date on the slider. I tried using a WINDOW_MAX calc, but I think I may be going down the wrong road:

       

      IIF(ATTR(DATETRUNC('month',[Post Date])) = WINDOW_MAX(ATTR(DATETRUNC('month',[Post Date]))),SUM([Value]),0)

       

      The ultimate goal is to show a trend-line of the values & dates with a BAN for the last date in the series. I've tried to demo this out in the attached workbook.