Get the name of a month - PowerPivot v2

Category: sql server powerpivotexcel


pscorca on Fri, 22 Mar 2013 16:55:53


I need to determine the month name as a calculated column into a Time table with a date field as the pk of the table.

I've used this formula: FORMAT(MONTH([Data]);"mmm")

but unsuccessfully.

Month names don't correspond with the month.

Any suggests, please?


Brent Greenwood on Fri, 22 Mar 2013 20:31:45

This one came up yesterday too. 

To use a date format (like "MMM" for month name), you need to pass the function a proper date.  Not just an int for the month part.

Try passing the full date (remove the MONTH() function).  And uppercase MMM is needed for month name abbreviated. 


Let me know if that helps.

pscorca on Sat, 23 Mar 2013 04:57:23

Ok, Brent, it functions. Many thanks.

I've read this blog:

So I think it was wrong.