6 Replies Latest reply on Dec 6, 2018 2:30 PM by Zhouyi Zhang

    Calculated measure :  For a specific date

    Eric WOLFF

      Hi,

      My issue is the following.

       

      I wish that by filtering on a date ([MyDate]) I display in a text box the value of a measure compared to the previous month.

       

      I would like to retrieve this value in a calculated field.

       

      I have the date back:

      DATEADD ('month', - 1, [MyDate])

       

      But not the value :(.

       

      Example :

      I have two month : september and october.

      On filter when i select octobre i want to have 266.50 in my text box.

       

      In the futur I want the possibility to recover x months, or x quarter, or x year, before

       

      Thank you in advance