Forum Discussion

JMAlloway's avatar
JMAlloway
Helper I
6 years ago

Help with Custom Date Column and Sorting

Hello All -   I am looking to figure out how to sort a custom date column. The date column takes data from January 1st 2018 - current and assigns the relative quarter and year. What's different is ...
AntrikshSharma's avatar
AntrikshSharma
Community Champion
6 years ago

you can create a column that lists out [Month Number] and based on this column you can sort your [Month Name] column by using the sort by column feature in the modelling tab.

  • JMAlloway's avatar
    JMAlloway
    Helper I
    6 years ago

    Thanks for your suggestion, Antriksh. Unfortunatly, the data goes back to January 1st 2018. If I try to do this, I recieve a cardinality error. 

     

    Here is how the visual shows up now:

     

     

     

    In need this sorted in calendar order.

     

    Thanks.