Forum Discussion
Creating a date table using only months and years
rrekker what about if you create a new column which you can prefix the date.
So as with your example you have the year of 2015 and the MonthNumber of 01, so when you create your new column create it as "01/01/2015" where the first 01 is the first day of the month?
You can then link that to your date table?
rrekker what about if you create a new column which you can prefix the date.
So as with your example you have the year of 2015 and the MonthNumber of 01, so when you create your new column create it as "01/01/2015" where the first 01 is the first day of the month?
You can then link that to your date table?
You are right in that I can get Month of Year from Google Analytics, add a 01 to it and connect this to the unique 01/01/2015 of the regular date table. Smart thinking!
This is the formula i entered in the new column:
Date = RIGHT([Month of Year],2)&"/01/"& LEFT([Month of Year],4)
Though not an exact solution to this question, it's a viable workaround. Cheers!