Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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 💡
Proud to be a Super User! | |
User | Count |
---|---|
103 | |
91 | |
79 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |