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 ...
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

JoeBarry's avatar
JoeBarry
Solution Sage
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