Back

Explore Courses Blog Tutorials Interview Questions

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

0 votes
2 views
in BI by (11.1k points)
edited by

Is there any possible way that I can get the month name from the month number?

enter image description here

enter image description here

1 Answer

0 votes
by (22.5k points)
edited by

Use this measure:

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

Looking for a comprehensive Power BI course? Enroll now!

Related questions

0 votes
1 answer
How to get current month in power bi
asked Mar 4, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
How to get data from Sharepoint excel datasource to Power BI desktop?
asked Dec 21, 2020 in BI by Chris (11.1k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...