Forum Discussion
Solved
Sorting by Month as Text (Jan Feb Mar etc)
I used Format to get mmmyy from Date. But in reports, data is being sorted alpha. I want mmmyy sorted by month
You need to create a sort column and use that as sort column for month
Month sort = format(Date[Date],"MM")
Month Year sort = format(Date[Date],"YYYYMM")
amitchandak
Super User
Super UserYou need to create a sort column and use that as sort column for month
Month sort = format(Date[Date],"MM")
Month Year sort = format(Date[Date],"YYYYMM")
Thanks Amit
