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.
Tlotly , i didn't understand what's the requirement, if you want the max date then it's giving it right.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
But the max date of this column is Feb 2023: I'm expecting Feb 2023 as a value for my column.