How to get month name from month number in Power BI

0 votes

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,520 points
6,164 views

1 answer to this question.

0 votes

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,890 points
1,027 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,890 points
3,181 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,890 points
2,336 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,890 points
4,805 views
0 votes
1 answer
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,890 points
6,724 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,890 points
842 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,890 points
1,792 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,890 points
831 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,890 points
22,446 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP