Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers


94k users

Browse Categories