6 Replies Latest reply on Mar 27, 2018 7:02 AM by Simon G.

    Selecting the value from different rows in a time Series

    Simon G.

      Hello,

       

      i have sell-price data in the following form:

      Artikel      valid from          new price          old price

      1               01.05.2017          4,99               3,99

      1               06.04.2017          5,99               4,99     

      1               11.12.2017          2,99               5,99            

      2               02.03.2017          1,99               0,99

      2               17.11.2017          2,99               1,99

      2               20.12.2017          3,99               2,99

       

      I want to have the exact price for each day in 2017, so i attached a column with the pure value 1 and inner joined a matrix consisting of:

      1     Date

      1     01.01.2017

      1     02.01.2017

      and so on.

       

      Now i want tableau to choose the right price for each day, meaning that for article 1 it should display 4,99 on 05.04.2017 and 5,99 on the next day.  

      How can i accomplish that?

       

      Any help appreciated!