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), "Pr...
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

     

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.