How to get month name from month number in Power BI

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

Sep 24, 2020 in Power BI by Roshni
• 10,480 points • 6,308 views

1 answer to this question.

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!

answered Sep 24, 2020 by Alisha

Related Questions In Power BI

0 votes

1 answer

How to create a new dashboard by pinning visualizations from a report in Power BI?

Hey, I can show some steps wise steps ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,770 points • 1,085 views

0 votes

1 answer

Add leading 0 (zero) to month number in power BI

You can use the FORMAT function for this: Expiry_MonthYear_Sorter = ...READ MORE

answered Oct 8, 2020 in Power BI by Gitika
• 65,770 points • 3,244 views

0 votes

1 answer

How to use Dynamic DAX Number Format in power BI?

You can give them the same display ...READ MORE

answered Dec 8, 2020 in Power BI by Gitika
• 65,770 points • 2,432 views

0 votes

1 answer

How to measure in DAX to calculate YTD for chosen month only for Power BI?

If you use the date column from FactTable, ...READ MORE

answered Dec 22, 2020 in Power BI by Gitika
• 65,770 points • 4,894 views

0 votes

1 answer

Error : Function 'GROUPBY' scalar expressions have to be Aggregation functions over CurrentGroup().

The error says you need to use ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,770 points • 4,310 views

0 votes

1 answer

How to ignore a slicer for one measure, but apply it on another?

In order to ignore Slicer you need ...READ MORE

answered Oct 1, 2020 in Power BI by Gitika
• 65,770 points • 6,904 views

0 votes

1 answer

How do I use the DAX function ParallelPeriod?

The DAX expression you used in the ...READ MORE

answered Oct 5, 2020 in Power BI by Gitika
• 65,770 points • 964 views

0 votes

1 answer

DAX. Problem with subtotals and grand totals

Create a new measure for the km ...READ MORE

answered Oct 5, 2020 in Power BI by Gitika
• 65,770 points • 1,863 views

0 votes

2 answers

Power Bi Questions

Hi, @Vnk, Despite the efficiencies achieved by the ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,770 points • 893 views

0 votes

1 answer

How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,770 points • 22,731 views

Subscribe to our Newsletter, and get personalized recommendations.

REGISTER FOR FREE WEBINAR

Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP