Forum Discussion
GemcoDesigns
6 years agoNew Member
Month Sorting
I have create one report( Purchase Monthwise.. But the months are not sorting... and it lokks like as per the image. Can any one help me to overcome this:)..
amitchandak
6 years agoSuper User
For the month and month year sorting; create sort column and mark them sort column
month year = format(date[date],"MMM-YYYY")
month year sort = format(date[date],"YYYYMM")
month= format(date[date],"MMMM")
month sort = format(date[date],"MM")
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin