4 Replies Latest reply on Jul 3, 2018 11:23 AM by Jessica Reason

    Calculated Field: Using two different measures and two different years

    Jessica Reason


      I can't figure this one out, and the other responses on the community are missing the mark because they say you need to do a Date calculation and put it on the filter (I can't do that). I am attaching a workbook (using superstore data) and it details what I am trying to do.


      But here is what I am trying to solve: I have two different measures and I want to create a monthly calculated field, but the catch is one of the measures should use 2018 data, and the other should use 2017 data.


      See attached for a jpeg and a packaged workbook. It uses the Sample-Superstore Data.


      Thanks for any advice you have!