Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Date Sorting

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

 

 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

     

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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

     

  • tarunsingla's avatar
    tarunsingla
    Solution Sage
    7 years ago
    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.