Forum Discussion

Yaa_D's avatar
Yaa_D
Frequent Visitor
4 years ago
Solved

Max date in a column

Hi All,  I have a date column called FileDate, and I'm trying to get the latest date in that column. I've tries using MAX or LASTDATE in the following ways:  maxFileDate = LASTDATE(('myTa...
MAX date
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Yaa_D Lose the .[Date] part of your formula and I would use MAX so:

    maxFileDate = MAX('myTable'[FileDate])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Yaa_D Lose the .[Date] part of your formula and I would use MAX so:

maxFileDate = MAX('myTable'[FileDate])
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello Greg_Deckler  , thank you for this tip . I also used it at a similar issue I had and it worked just fine . May I ask what is the implication of using the .[Date] at the end? Thank you, George Giannakis