Month Name

[mrshl9898]

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.

 

[JLGWhiz]

Didn't notice the last remark.

 

[sandy666]

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

maybe:

[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

 

[mrshl9898]

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

 

[sandy666]

I assume we are talking about the same thing - DAX
could you tell me what is your table name (table with Date column)?

 

[ralliartur]

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