Month Name

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,055
Hi,

I'm using the following

Month = FORMAT(MONTH(Sheet1[Date]),"MMMM")

To get the month name, however, all Jan dates are showing as December, the rest are showing January.

Any ideas what could be wrong? Sheet1[Date] is a date data type.



*All good, worked it out.
 
Last edited:

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
11,412
Office Version
2013
Platform
Windows
Didn't notice the last remark.
 
Last edited:

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,192
= FORMAT(MONTH(Sheet1[Date]),"MMMM")
maybe:
Code:
[SIZE=1]=FORMAT(MONTH([B][COLOR="#FF0000"]Table1[/COLOR][/B][Date]),"MMMM")[/SIZE]
edit:
but if your table has name: Sheet1 so I don't know what is wrong
 
Last edited:

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,055
It was =FORMAT(Sheet1[Date],"MMMM") in the end.

Looks like FORMAT(number,"MMMM") works on days of the year by default

1 = DEC
2 = JAN
33 = FEB
 
Last edited:

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,192
I assume we are talking about the same thing - DAX
could you tell me what is your table name (table with Date column)?

 

ralliartur

New Member
Joined
Apr 15, 2015
Messages
30
I assume we are talking about the same thing - DAX
could you tell me what is your table name (table with Date column)?
This is not the case - OP made a mistake using numbers for month 1..12 and then used Format to get month name which is wrong, as excel needs full date to get month name in the right way. If you want to resolve it in this case you need to change source column to full date or use formula like date() with hardcoded year and day like FORMAT(date(2018, Sheet1[Date], 1), "MMMM") - i'm assuming heare this date column was in fact month stored as number.

BTW @mrshl9898 - please read this on how excel is storing date http://www.cpearson.com/excel/datetime.htm
 
Last edited:

Forum statistics

Threads
1,085,229
Messages
5,382,457
Members
401,788
Latest member
zenattitude

Some videos you may like

This Week's Hot Topics

Top