3 Replies Latest reply on Apr 30, 2017 3:34 AM by Julia Balkheimer

    Get last date and corresponding value

    Julia Balkheimer

      Hi everyone,


      I am able to get th elast day from different dates, however I have issues of receiving the value of another variable for the last date.


      I am calculating the last date this way:

      Latest date:




      As a last step I would like  to get the value of the KPI in "col35" for the last day

      LOOKUP(WINDOW_SUM(sum(IIF([Latest Date],[Col35],0))),0)

      Can you please advise why I get the an aggregation error?


      I would like to the same for YTD and MTD.

      How do I calculate YTD, MTD?