YEAR and MONTH function

[waleed111]

i write this formula:

Year A = YEAR('All Manufacturings (4)'[Added Time])

but when i try to covert it to date type it show wrong value, it show me 1900 for all value, what is the problem?

[amitchandak]

@waleed111 , it may be because it is time or has data type as time.

Only time will have a year 1900

[waleed111]

 It is of type date.

[amitchandak]

@waleed111 , this is strange, Can you share sample  pbix after removing sensitive data.

Try this

Year A = format('[Added Time],"YYYY")

Hope you do not have another table. Try without a table name

Year A = YEAR('[Added Time])

[waleed111]

when i use:

Year A = format('[Added Time],"YYYY")

it show me this error: cannot convert value to date.

[v-easonf-msft · Accepted solution]

Hi, @waleed111 

I can reproduce your issue here.

I guess that you column "Year A" is of type "DATE".

As mentioned in this document ,function "Year"  returns the year of a date as a four digit integer in the range 1900-9999.

It is suggest to convert your column  "Year A" to type "text"  

Best Regards,
Community Support Team _ Eason

[FuadAliyev]

Hi @waleed111 can you show your AddedTime column data?