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!