Convert numbers to month

Hi Anonymous,

---

The month column is RS month. I need to convert thos numbers in text as Jan, Feb, Mar, etc. but keeping the monthly order when showed in a graph.

---

In this scenario, you can use the formula below to create a new calculate column to convert the numbers in text as Jan, Feb, Mar, etc. :smileyhappy:

Short Month =
SWITCH (
    Table1[RS Month],
    1, "Jan",
    2, "Feb",
    3, "Mar",
    4, "Apr",
    5, "May",
    6, "Jun",
    7, "Jul",
    8, "Aug",
    9, "Sep",
    10, "Oct",
    11, "Nov",
    12, "Dec",
    BLANK ()
)

To keep the monthly order for the "Short Month" column, you can use the 'Sort by Column' option under Modeling tab.

1. Select "Short Month" column.
2. Click 'Sort by Column' option under Modeling tab.
3. Select "RS Month" column.

Regards