1 2 Previous Next 21 Replies Latest reply on Jun 11, 2018 4:11 AM by Mavis Liu

    If Calculation: All measures from a Year but select the value of an other measure from previous Year

    Anton Scharton

      Hi there,

       

      I want to include a calculation for a measure which allows me to do that:

       

      IF Year

      THEN Value of Sales from previous Year

      END

       

      ---

      If I filter for a year (e. g. 2017) I want that all measures are shown from Year 2017 besides one (Sales). For Sales the values from the previous Year (in this case Year 2016) should be shown.

       

      Can anyone help with the syntax?

       

       

      Thank you in advance.

      Anton

        1 2 Previous Next