Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
2 years ago
Solved

Sort Calendar Table

Hi all,

I am trying to sort my Calendar Table to display properly. My Column is MMM, YYYY.
I tries soerting by year then month number but that give me either

Jan, 2011

Jan, 2012,
Jan, 2013

or

Apr, 2011

Aug, 2011

Dec, 2011

 

How can I sort so displays

 

Jan, 2011

Feb, 2011

Mar, 2011

Thanks,

-w

Need Help
  • JoeBarry's avatar
    JoeBarry
    2 years ago

    Hi UncleLewis 

     

    With in my Date table I created a Month Index column and converted then to number

    Month Index = Format('DIM Date'[Date], "YYMM")

     

     

    I then Sorted the MMM, YY column by this index Month. As it is taking the year first, it will sort properly

     

    Thanks

    Joe

     

    If this post helps, then please Accept it as the solution

3 Replies