5 Replies Latest reply on May 9, 2018 10:32 AM by Joe Oppelt

    Creating measure that returns historical data while having a date filter

    Charlie Frost

      Hi everyone,

       

      I'm having trouble creating a calculated field that returns the value of a measure for the prior two months that can co-exist with a date filter. The granularity of the data is at a monthly level, so I'm concerned with data for (month-1) and (month-2). The issue I'm trying to bypass is having the date filter work properly, along with keeping my calculated field intact. For example, if I select June 2017 with my filter, that means Apr and May are now filtered out, which affects the calculated field that looks at (month-1) and (month-2). Any creative suggestions for making both of these things work in parallel?

       

      Thanks in advance for any insight and advice.