cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nagaraj007
Post Patron
Post Patron

Month name not showing correctly

Hello All,

 

I have date column based on that i extracted month number  

Month no. = MONTH('Resigned&Removed'[expulsion_date])
When i try to get month name based on 
Month = FORMAT('Resigned&Removed'[Month no.],"mmm")
 
I get wrong month name. Below is the screensnip for your referencewrong month name.png 
 

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @nagaraj007 

Try this

 

Month = FORMAT(DATEVALUE('Resigned&Removed'[expulsion_date]),"mmm")

 

month-name.png

Phil


If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
PhilipTreacy
Super User
Super User

Hi @nagaraj007 

Try this

 

Month = FORMAT(DATEVALUE('Resigned&Removed'[expulsion_date]),"mmm")

 

month-name.png

Phil


If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

ibarrau
Super User
Super User

Hi. I don't think you can use format that way. It will format a number to an specific way or a date to an specific way. The thing is you are trying to format a number as a date. If you want the month number you might want to use "mmm" with a Date as the value like FORMAT(Table[DateColumn], "mmm")

Hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!