So I have a date dimension and I have the month offset in there from Current Day. What I want is to be aboe to add a slicer to the report that will offer the opportunity to select date periods
“Last Three Months”
“Last 6 Months”
“Last 13 Months”
It had occured to me that I could just add these 5 as a column to the date table and have a zero or one if the date falls within that range. However I want something more flexible - so in the future I dont have to add a whole load of columns to the date table.
I was thinking of having a seperate table Called Period Selector that could have
Period Selector StartMonthOffset EndMonthOffset
Current Month 0 1
Previous Month 1 2
Last 6 Months 0 5
But it is how to join to the data table?
Any suggestions appreciated.