How to get month name from month number in Power BI?
You can use:
MonthName = FORMAT(DATE(1, [Num], 1), "MMM")
Result:
Nothing fancy, simply a reconstruction of a fake date from the month number provided, and reformat it with the FORMAT
function.
Of course as an alternative you can go the old-fashioned way and write a SWITCH
statement and hard-coded for the 12 months. It's up to you.
You can try this too:
Month name = FORMAT('Table'[date_column], "MMM")
If you use single quotes in 'MMM', it doesn't work. Ensure to use ""