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 s...
Resolved. It was the date itself. Sap has thown me a wierd year. 2202 not 2022 dont know how I didnt see that.
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 nullResolved. It was the date itself. Sap has thown me a wierd year. 2202 not 2022 dont know how I didnt see that.