Forum Discussion

Tlotly's avatar
Tlotly
Helper V
3 years ago
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 ...
Need Help
  • myon's avatar
    myon
    3 years ago

    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.

     

Idrissshatila's avatar
Idrissshatila
Super User
3 years ago

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's avatar
    Tlotly
    Helper V
    3 years ago

    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.