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

     

     

Salvador's avatar
Salvador
Responsive Resident
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

That won't work as I do not have a table view; this is a Direct Query.

    • averilboyle's avatar
      averilboyle
      Frequent Visitor
      9 years ago

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

    • PAPutzback2's avatar
      PAPutzback2
      Helper II
      5 years ago

      FYI, The link from Tom Marten is the correct fix when dealing with a table that load via Direct Query. Which was the problem stated in the OP. The suggested solution is partially right, except that you won't see the table in the Model view. You have to select the column in the table to get the option to Sort by Column to appear.