Sorting Dates

Hi v-jiascu-msft,

I am sorting NBA dates data into season and season type.

For the 2012-2013 season.

Season Type = SWITCH(TRUE(),

'Merge1'[Date] >= DATE(2012,10,5) && 'Merge1'[Date] <= DATE(2012,10,29), "Preseason",

'Merge1'[Date] >= DATE(2012,10,30) && 'Merge1'[Date] <= DATE(2013,04,19), "Regular season",

'Merge1'[Date] >= DATE(2013,04,20) && 'Merge1'[Date] <= DATE(2013,06,5), "Playoffs",

'Merge1'[Date] >= DATE(2013,06,06) && 'Merge1'[Date] <= DATE(2013,06,20), "Finals",

'Merge1'[Date] >= DATE(2013,06,21) && 'Merge1'[Date] <= DATE(2013,10,4), "Offseason"

I have 8 seasons of data.

Each season has different starting dates for the preseason, regular season etc.

Would I have to copy and alter this code for each of the 8 seasons .

Or is there an alternative?

Thanks in advance