6 Replies Latest reply on Oct 8, 2018 4:53 AM by Zhouyi Zhang

    Finding next date w/o table calc

    Anika Brust

      Hello everybody,

       

      I have a table on price changes for each product which looks basically like this:

       

      I need to know the start and end date of each price for each product.

       

      So I'm looking for a calculation (or join?) to make the [created at]-Date of the next Price Change ID to be the [Left at]-Date of the named ID. Just like that:

       

      And to make it a bit more interesting: I cannot use any table calcs as I need to go on joining and calculating based on those two dates,

       

      I have tried some LOD calcs and joining - both in Tableau Desktop and Prep, but I wasn't able to find a solution.

       

      Does any of you have an idea?

       

      Thanks in advance and have a nice weekend!

      Anika