DAX - Extract Month name from Date - not working

[Omar_204]

Hello all,

I am trying to extract the month name from a date column and its displaying same as the date.

Here is the code I am using:

DateTimeMonthYear= ADDCOLUMNS(SELECTCOLUMNS(Morale & Workload List,"Date",'Morale & Workload List [Completion time]),"Month", MONTH([Date]),"Month Name", FORMAT([Date], "mmmm"),	"Year",Year([Date]))

The issue is for the Month Name column its display same as the date/time i.e. YYYY-MM-DD HH:MM:SS AM/PM

I don't understand why it's not extracting the Month name, can anyone help ?

Thank you.

[Omar_204]

I just checked the Completion time field with the Date/Time and the format was Text, not Date/Time. As soon as I changed this, its now showing the Month.

[Greg_Deckler]

@Omar_204 That would certainly cause problems!! 🙂

[Omar_204]

That's exactly what I am using the same code, so howcome it works here but not on mine. Could it be something to do with the sharepoint list ?

[Omar_204]

Hello, 

Sorry, thats what I have it uses single quotes but still displays the date and time not the Month

[Greg_Deckler]

@Omar_204 Your syntax looks correct except for not having single quotes around your table name references. I recreated just fine in a PBIX attached below sig.

[Omar_204]

Hello,

I am having the same issue to extract the Month name from a date/time.

Here is my code: 

DateTempsMoisAnnee = ADDCOLUMNS(SELECTCOLUMNS('Formulaire d''indicateur de moral et de capacité de charge de travail',"Date",'Formulaire d''indicateur de moral et de capacité de charge de travail'[Le temps d'exécution]),"Numbéro de Mois", MONTH([Date]),"Nom du Mois", FORMAT([Date],"mmmm"),"Année",Year([Date]))

For the Nom du Mois column, its shows the same as the Date column in the format YYYY-MM-DD HH:MM:SS AM/PM.

Any ideas, I checked the column types and they all seem correct.

Also, would it be simple to have the output translated into French ?

January -> Janvier, February -> Fevrier.

Or does it only output the result of the DAX code into English ?

Thank you.

[Greg_Deckler]

@Omar_204 What desktop version are you on?

Mine is:

Version
2.108.603.0 64-bit (August 2022)

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".