Forum Discussion
Solved
What's wrong with excel data model Month function malfunctioning
is this a known issue?
That could mean you have texts which looks like date, not dates (aka numbers). Please check in Format, is it
or
14 Replies
As a comment:
In DAX day number one is Dec 31, 1899. Thus MONTH(1) returns 12, i.e. December
In Excel day number one is Jan 01, 1900. Thus MONTH(1) returns 1, i.e. January.
- it seemed to work on this time period thing. I'll have to see if it will work still:
https://social.technet.microsoft.com/wiki/contents/articles/1018.powerpivot-grouping-by-dates-months-quarters-years-etc-in-pivottables.aspxI only tried to explain why
=FORMAT( 1, "mmmm")in DAX returns December, not January.
Actually you need to use another field as Subodh_Tiwari_sktneer suggested.
Shouldn't the formula refer to the date column (Week of:) instead of the column with month number?
- that was my first formula =MONTH([COLUMN1])
