Forum Discussion
Solved
Max date DAX
Good day, I'm creating a column with a simple measure but it's returning a wrong date of 31 Dec 2023. Please see below Column = max('Drop-Out details'[DropOutGLDate].[Date]) Any idea why ...
The .[Date] part refers to a auto generated calendar that PBI created on load. It searches your data, finds dates and creates a calendar with full years encompassing all of your data.
Try removing the .[Date] part.
