Forum Discussion
Full Month Word from MM/DD/YYYY format
I have a table in Power BI with dates in the format MM/MM/YYYY
I'm trying to get the full month name...for example...I want January.
I created a new column using the formula Month = FORMAT([Eff Date],"MMM") but this only results in Jan.
What is the correct way to extract the month word in full?
Hi Anonymous
try
Month = FORMAT([Eff Date],"mmmm")there is a complete list of format date options https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
do not hesitate to give a kudo to useful posts and mark solutions as solution
4 Replies
- Greg_Deckler
Community Champion
It is mmmm - az38
Hi Anonymous
try
Month = FORMAT([Eff Date],"mmmm")there is a complete list of format date options https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
do not hesitate to give a kudo to useful posts and mark solutions as solution
- az38
Anonymous
is my previous solution ok?
do not hesitate to give a kudo to useful posts and mark solutions as solution
