Max date DAX

[Tlotly]

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 this would be?

Thank you in advance.

[myon · Accepted solution]

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]

Thank you so much @myon . It worked, I removed the date part.

[myon]

You are most welcome.

[Idrissshatila]

@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 👍

Follow me on Linkedin

[Tlotly]

But the max date of this column is Feb 2023: I'm expecting Feb 2023 as a value for my column.

[Idrissshatila]

Hello @Tlotly ,

so the measure is returning the maximum date in all the column, regarding if you filtered it in the data view.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Tlotly]

@Idrissshatila  thank you for the quick response.

So which measure would work? I even created a measure, still getting the same results.

Also tried this measure:

Column = CALCULATE(MAX('Drop-Out details'[DropOutGLDate].[Date]),ALL('Drop-Out details'))

, still not working.