Forum Discussion
Not showing correct Max date Power query/ Power BI
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.
2 Replies
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
