Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.