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.