Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sorting Dates

Hi,   Currently I am trying to sort a selection of dates from 2010-2015 into two categories.   The season it occurred eg 2011-2012 and then whether it is preseason, regular season or playoffs.  ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

     

    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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

If the dates start from different dates without any rules, I'm afraid you have to repeat them. Can you share the details, please?

 

 

Best Regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

 

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