How to get month name from month number in Power BI?

business-intelligence powerbi dax
Serdia picture Serdia · Mar 23, 2017 · Viewed 57.7k times · Source

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 its very easy. But how to achieve that using DAX?

enter image description here

enter image description here

Answer

Foxan Ng picture Foxan Ng · Mar 23, 2017

You can use:

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

Result:

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.

Related questions

No QUARTER() in DAX? Really?

While building a Calendar table with PowerQuery for a PowerPivot model in Excel 2013 I use its Date.QuarterOfYear function to get the number of the quarter. Building the same thing in SSAS Tabular requires some workarounds. There's no equivalent DAX …

Read More
How to use SQL Server stored procedures in Microsoft PowerBI?

I want to generate reports from my SQL Server tables. I have some already made stored procedures that I would like to use to generate reports from. I haven't found a way to do so. Only by rewriting the queries. …

Read More
Microsoft business intelligence platform vs QlikView

I have no experience at all with QlikView, but I have read great reviews about it. According to Gartner Research Report 2012, QlikView is in the top quadrant together with Microsoft, Oracle, SAP and IBM (leaders and visionaries). I am interested …

Read More