Sort Calendar Table

[UncleLewis]

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

[UncleLewis]

Thanks @JoeBarry ,

Works great!

[JoeBarry · Accepted solution]

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

[Idrissshatila]

Hello @UncleLewis ,

Refer to this video https://youtu.be/yx-Duj_KPtw?si=CgODPULaMw7xqJEH

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡