3 Replies Latest reply on Feb 21, 2017 3:28 AM by André Coelho

    Date Periods

    André Coelho

      Hello!

       

      I'm Trying to work with a date dimension called [Dtdistrato]. It's data since 2007.

       

      All I want to do is create time periods until the end of my dataset.

       

      - Period 1: from (today) until (today - 36 months)

      - Period 2: from (today - 12 months) until (today - 48 months)

      - Period 3: from (today - 24months) until (today - 60 months)

      - ... and keep going on ...

       

      eg.:        (mm.dd.yyyy) to (mm.dd.yyyy)

      Period 1: (02.20.2017) to (02.20.2014)

      Period 2: (02.20.2016) to (02.20.2013)

      Period 3: (02.20.2015) to (02.20.2012)

      Period 4: (02.20.2014) to (02.20.2011)

      ...

       

      Any ideas?

       

      Mensagem editada por: André Coelho