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
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.
At first it was as what as @Subodh_Tiwari_sktneer suggested because I'd rather get the translation directly from the original value/date and it was December that's why I tried doing a go between as you can see in the image, just to make sure I wasn't dreaming up things.
