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,420 points
124 views

1 answer to this question.

0 votes

You can use:

MonthName = FORMAT(DATE(1, [Num], 1), "MMM")
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,870 points
231 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 7, 2020 in Power BI by Gitika
• 65,870 points
518 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,870 points
252 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,870 points
229 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,870 points
1,620 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,870 points
108 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,870 points
201 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,870 points
112 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,870 points
4,312 views