Year showing as 211, 122, 218 etc...

[id7]

Hi All,

I'm currently having a problem where the year is displayed incorrect.

Data is valid and set to U.K. date.

I've checked all of the data and there is no discrepencies. 

I found another article refering to this same issue here: Solved: Year 2020 displaying as "202" - Microsoft Power BI Community

User was advised to use "Never detect column types and headers for unstructured sources." which made no difference for me.

Any help would be greatly appreicated.

[id7 · Accepted solution]

I managed to resolve this by fixing errors in my Excel data. 

Dates were entered wrong and formatted incorrectly.

[amitchandak]

@id7 , how you got this year?

You created like

= year([close Date])

[id7]

I have it setup like this.