DAX Date Sorting

[Anonymous]

Hi,

I am sorting NBA 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

[tarunsingla]

Not sure what all data you have, but you can dump the season metadata like season, season type, start date and end date in another dataset and then create a relationship between your actual datset and the season metadata. You wont need to duplicate this dax then and can work with season start date and end date alone.

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

---

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

Or is there an alternative? 

---

I think you may have to copy and alter this code for each season data.

Regards,

Yuliana Gu