Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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?

closed

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

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...