Forum Discussion

averilboyle's avatar
averilboyle
Frequent Visitor
9 years ago
Solved

Month Name in sorting order in Direct Query

Hi   I have a direct query where I have added a new column from the date field.  In this column I have the following formula:   MonthName = SWITCH(MONTH(Query1[Date Raised]),1,"January",2,"Februa...
Need Help
  • Salvador's avatar
    Salvador
    9 years ago

    Hi,

     

    Create a column that is xxx = month(query1[date raised]))

    Idk if you already have it already, if you have it, no need to create it :D, and then, you just need to sort the MonthName by the column that gives the month number :P

     

     

averilboyle's avatar
averilboyle
Frequent Visitor
9 years ago

All working now; the month no. column was what was missing :)