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

    Calculated measure :  For a specific date

    Eric WOLFF


      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