Forum Discussion
Month Sorting
Hi all i have a date column and from that column i extract month and year like this Extract Month Name Month Name = FORMAT (Data[Date Main], "MMM" ) Extract year Year = YEAR(Data[Date Main])...
Did you perhaps chose to sort column [Month] by column [Month Name]?
in Month there is numbers and in month name there is names like jan, feb.. so i have to choose number column when i select name column TODEI
What I meant is that you can' sort column [Month] by column [Month name] and at the same time sort column [Month name] by column [Month].
Make sure that you only sort one way, not both ways.
then what should i do