Forum Discussion
nagaraj007
Post Patron
Post PatronMonth 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 reference
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.
2 Replies
- PhilipTreacy
Super User
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,
