How to get month name from month number in Power BI

Question

I have Year number and Month Number in my data. How using DAX can I get the month name out of month number?

Answer 1

You can use:

MonthName = FORMAT(DATE(1, [Num], 1), "MMM")

If you are interested in learning Power BI, check out Power BI Course Topics now!