Problem:
How do you get a Month Name from a date field in Power Pivot?
Solution:
here’s a code snippet that should help:
[code language=”SQL”]
=FORMAT([date],"MMM")
[/code]
This should give you month names (Jan, Feb, …) instead of integers that are returned by the MONTH function.
couple of notes:
1. date field needs to be used to get the month name
2. MMM needs to be in uppercase.
I hope this helps.