cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LawrenceKay Regular Visitor
Regular Visitor

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: DAX Date Sorting

Hi @LawrenceKay,

 


 

 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

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: DAX Date Sorting

Hi @LawrenceKay,

 


 

 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

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tarunsingla Member
Member

Re: DAX Date Sorting

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.