Forum Discussion
Solved
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.
hI mohammadyousaf ,
Create a calculated column FORMAT (tbl[Date], "yyyymm") and then use it to custom sort the Month Year column by.