Fail to convert integers to month or year

[Anonymous]

Hi everyone
I try to use the formula year(ordPubAno); ordPub ano is formatted as whole number. 

The result of conversion for example for 2004 is 1905 but  it should be 2004.

I try to convert also a month(ordPubMês) odrPubMes is formatted as whole number and for example for 8 convert to 1 instead of 8.

Can you help?

[Cmcmahan · Accepted solution]

The YEAR and MONTH functions expect a datetime object, not an integer.  When you pass an integer, DAX assumes that is the number of days that have passed since Dec 31, 1899.  So when you get the YEAR(2004), you're actually getting the year 2004 days after Dec 31, 1899.  Same with MONTH(8), which returns 1 since 8 days after Dec 31, 1899 it is January.

My question is why you're trying to convert a value that is a year into a year? You're expecting a result of 2004 when you input 2004 into the function. You already have the value you're expecting to come out of the function, so just use that.