How to get month name from month number in Power BI
Published on Jul 08,2024:
In this video, we will learn to extract month short name from the date field in Power BI.
Formula Explanation of the formula used
DATE(1, [Date].[MonthNo], 1):
This function constructs a date.
The first 1 represents the day part of the date.
[Date].[MonthNo] is a variable or field that holds the month number (for example, 1 for January, 2 for February, etc.).
The second 1 represents the year part of the date. In this context, the year doesn't affect the outcome since only the month name is needed, so a placeholder year 1 is used to complete the date format.
FORMAT(..., "MMM"):
This function takes the date generated by the DATE function and formats it as a string.
"MMM" specifies that the date should be formatted to show only the three-letter abbreviation of the month (e.g., "Jan" for January, "Feb" for February, etc.).
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!
/ @learnexcelrelentless
Our Playists:
SQL Playlist :https://goo.gl/PS5Ep6
DAX PlayList : https://goo.gl/S4W41D
Power BI PlayList: https://goo.gl/dXxvnB
Power Query Playlist: https://goo.gl/5QS7P4
Getting Started with Power BI:https://goo.gl/GHakLZ
Getting Started with Python: https://goo.gl/n24P3w
ABOUT DAGDOO:
Website:
Home Page: http://www.dagdoo.org/
Power BI Tutorials: http://www.dagdoo.org/excel-learning/...
Questions? Comments and SUGESTIONS? You will find me here:
Twitter: @dagdooe
Category: Science & Technology
License: Standard YouTube License
Watch video How to get month name from month number in Power BI online without registration, duration hours minute second in high quality. This video was added by user Learn 2 Excel 08 July 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 169 once and liked it 1 people.