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 in Power BI by Roshni
• 4,810 points
31 views

1 answer to this question.

0 votes

You can use:

MonthName = FORMAT(DATE(1, [Num], 1), "MMM")
answered Sep 24 by Alisha

Related Questions In Power BI

0 votes
1 answer
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 in Power BI by Gitika
• 42,520 points
33 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 51,970 points
785 views
0 votes
3 answers

How do I get token using javascript API while trying to embed graphs using Power BI

Use ADAL.js that will give you an ...READ MORE

answered Jun 22, 2019 in Power BI by anonymous
2,006 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 in Power BI by Gitika
• 42,520 points
71 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 in Power BI by Gitika
• 42,520 points
27 views
0 votes
1 answer

DAX. Problem with subtotals and grand totals

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

answered Oct 5 in Power BI by Gitika
• 42,520 points
26 views
0 votes
2 answers

Power Bi Questions

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

answered Sep 24 in Power BI by Gitika
• 42,520 points
84 views
0 votes
1 answer