Forum Discussion
Single year from date range
whothefoo seems interesting stuff to do. In this case you want to create fiscal calendar which is basically a season based and then have a column showing the year 2000-2001 , 2002-2003 etc. All the magic is going to come from fiscal calendar dimension. Hope it make sense. You can google on fiscal calendar and I'm sure you will get many blogs on how to use it.
whothefoo seems interesting stuff to do. In this case you want to create fiscal calendar which is basically a season based and then have a column showing the year 2000-2001 , 2002-2003 etc. All the magic is going to come from fiscal calendar dimension. Hope it make sense. You can google on fiscal calendar and I'm sure you will get many blogs on how to use it.
Yes :) took a bit of playing around with things I didn't understand but it's sorted now.
Thank you
If anyone is interested it's a mixture of using left and right commands to make two columns with the start and end year from the 2010-2015 style range.
Subtract the start column from the end to give a count of how many duplicate rows you need then follow the below:
https://www.youtube.com/watch?v=cXb308NPU2M
* I did have to add the final index column into the formula when expanding the rows but it's given me a duplicate row for each with a value of 0-however many dupliates there are.
Now I can just add that value to the start date and add one to create the end date and concat back to get a start to end range - for 2010-2015 - index 3 - add index (in the case 3) to start (2010) add one more for the end date and concat = 2013-2014.
For the next dipicate row the index is 4 so it will make 2014-2015.
phew lol