Not showing correct Max date Power query/ Power BI

[Anonymous]

Hello I have a very strange error. In that the max date is incorrect. In this case the max date should be 30/05/2022, but shows 23/05/2022.

I have made sure that the location is correct with in settings. (UK). Also comfirmed that no errors exist.

Within Power Query, column is set to date format, but even if sorted shows 23/05/2022 as top.

At first I though the data is not there. However when checking 30/05/2022 is comfirmed.

.

Within Power BI 

max or Maxx both show.

I am truly baffled. Any help would be grateful.

[Vijay_A_Verma]

In a custom column, put following formula and extract date. Then delete the original column and rename this column to Week. 

= try Date.From([Week]) otherwise null

[Anonymous · Accepted solution]

Resolved. It was the date itself. Sap has thown me a wierd year. 2202 not 2022 dont know how I didnt see that.