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.