How do you get a Month Name from a date field in Power Pivot?
here’s a code snippet that should help:
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.