6 Replies Latest reply on Jan 14, 2019 6:20 AM by Tushar More

    Calculate a date and display the day value.

    Audrey Jagot

      Hello,

       

      I would like some help to do something.

       

      I have a big data set with different values for each day. I simplified it :

      I have created a dashboard with 3 calculated fields. Now I try to display the price of yesterday, one week ago and one month ago. It is the equivalent of the excel function vlookup but I don't understand how to proceed with tableau.  I find a solution but I don't want to duplicate the sheet . It is a dynamic table because each day, we have different dates.

       

       

       

      Thanks a lot fot your help

       

      Audrey