Forum Discussion
Sort by multiple years & months
I have custome Calendar Table in my model but can't sort out the months by mmm yyyy, can someone please help with this,I have tried multiple ways.
Sort Column
Sort Visuals by Month
Thank you
Hi mohammadyousaf - can you please try the below solved solution.
SortOrderYearMonth =
Year(Table[Date])&Month(Table[Date])Solved: Sorting Year-month sequentially - Microsoft Fabric Community
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!hI mohammadyousaf ,
Create a calculated column FORMAT (tbl[Date], "yyyymm") and then use it to custom sort the Month Year column by.
3 Replies
Hi mohammadyousaf - can you please try the below solved solution.
SortOrderYearMonth =
Year(Table[Date])&Month(Table[Date])Solved: Sorting Year-month sequentially - Microsoft Fabric Community
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!hI mohammadyousaf ,
Create a calculated column FORMAT (tbl[Date], "yyyymm") and then use it to custom sort the Month Year column by.
Hi mohammadyousaf ,
Did danextian rajendraongole1 reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.
Best Regards,
Adamk Kong
