Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)

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

In SSRS it is very easy. But how to achieve that using DAX?


1 Answer

0 votes
by (47.2k points)
selected by
Best answer
  • We can use :

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

  • We need a simple reconstruction of a fake date from the month number provided, and reformat it with the FORMAT function.

  • As an alternative, we can go the old-fashioned way and write a SWITCH statement and hard-coded for the 12 months. It's up to you.

Check out the Power BI Microsoft certification course provided by Intellipaat to learn and master this tool. 

Related questions

Browse Categories