2 Replies Latest reply on Jul 30, 2018 11:54 PM by Khalid Baker

    How can I duplicate a measure value in Tableau?

    Khalid Baker

      Hey Everyone,

       

      I have a set of data with prices certain products over 2 year (2017-2018). Suppose only two market prices change in 2018, so only 2 records are added for 2018.

       

      Logic in Tableau: If the price is null or blank then duplicate precious month entry for price. Example: Bahrain in January 1st 2017 had price 300 & price did not change at all for over a year. Therefore, I would to duplicate for each month since it is a constant so that prices for each month remains 300.

       

      How can I run this logic?

       

      Kind Regards;

      Khalid Baker