Change Month number to name in DAX

[hmeltonPSL]

I have a direct Query.  Using the formula below to create the Month in my date hierarchy.  I really need the Month Name but can't use Format in my function.  How do I get the name to appear and not the number but also sort correctly in the graph?

Month = Month('Reports_vwAllWorkOrders'[DATECOMPLETE])

Thank you!

[hmeltonPSL]

SWITCH worked.

Monthname = SWITCH(Reports_vwAllWorkOrders[Month], 1,"Jan", 2,"Feb",3,"Mar",4,"April", 5,"May",6,"Jun",7,"Jul",8,"August",9,"September",10,"October",11,"November",12,"December")

[collinq · Accepted solution]

Hi @hmeltonPSL ,

Direct Query adds a challenge to this but the easiest way is probably to make two separate DAX columns.  

The first one is to create the Month Number like this:
MonthNumber = MONTH('Reports_vwAllWorkOrders'[DATECOMPLETE])

Then, you can use a "Switch" to change the number to words:
MonthName =
SWITCH(
MONTH('Reports_vwAllWorkOrders'[DATECOMPLETE]),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
12, "December"
)

Then, sort by the "MonthNumber" but show the "MonthName"