5 Replies Latest reply on Jul 31, 2018 12:32 PM by Mahfooj Khan

    Calculate difference between measures for different periods (month, quarter etc)

    Kamil Nikiel

      Hi All,

       

      I got puzzled with the following:

       

      Have a data like:

       

          

      IDFrequencyDateValue
      Dummy1Monthly2018-03-0110
      Dummy1Monthly2018-02-0120
      Dummy1Monthly2018-01-0130
      Dummy2Quarterly2018-06-01100
      Dummy2Quarterly2018-03-01200
      Dummy2Quarterly2018-09-01300
      Dummy3Annual2018-01-011000
      Dummy3Annual2020-01-011100
      Dummy3Annual2019-01-011200

       

       

      The view i want to achieve:

           

      Name2nd to last valuelast valuecurrent valueDiff (current - last)
      Dummy1302010-10
      Dummy2100200300100
      Dummy3100011001200100

       

       

      Any idea how can I achieve this?Many thanks for your help in advance