Month name not showing correctly

[nagaraj007]

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 reference 

[PhilipTreacy · Accepted solution]

Hi @nagaraj007 

Try this

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

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.

[ibarrau]

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,