Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BiBra
Helper III
Helper III

number to month name

I want to convert month numbers to names, this is what i tried:

 

Short Month = 
SWITCH (
    'YM'[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 ()
)

However it gives me a "syntax incorrect" for every month name. Anyone know why this is?

1 ACCEPTED SOLUTION
jthomson
Solution Sage
Solution Sage

Should be all commas or all semicolons depending on your version

View solution in original post

1 REPLY 1
jthomson
Solution Sage
Solution Sage

Should be all commas or all semicolons depending on your version

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.