Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Omar_204
Helper I
Helper I

DAX - Extract Month name from Date - not working

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.

7 REPLIES 7
Omar_204
Helper I
Helper I

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.

@Omar_204 That would certainly cause problems!! 🙂



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Omar_204
Helper I
Helper I

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
Helper I
Helper I

Hello, 

 

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

Greg_Deckler
Super User
Super User

@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.

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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.
 
Omar_204_0-1675270837666.pngOmar_204_1-1675270849216.png

 

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.

@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".



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.