Power Pivot: How to get Month Name from a date field?



How do you get a Month Name from a date field in Power Pivot?


here’s a code snippet that should help:

[code language=”SQL”]

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.

What do you think? Leave a comment below.