show null values for the missing years data

[vidyasagar159]

Hi All,

Hope you are doing great. I have a small requirement. As I am working on product historical data. This product launched in 1976 (Product Inception Date) with some sale figure. But I have the data available from only 1985 (Year).

So Product Age = Product Inception Date - Year 

Since I don't have data from 1976 to 1984 I would like to show null values in the Year Column. 

[saminea_ANZ]

Please generate the calendar from 1976 to data available? So, It will generate with null values where data is not available and remain will store from source and linked together.

[vidyasagar159]

I got this idea already. But the tough part is I have millions of products like this on top of this the source files are excel. Of Course, it can be done by adding more calendar years in excel. Just checking in if there are any alternatives like ApplyMap().. etc.