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])
Yaa_D's avatar
Yaa_D
Frequent Visitor
4 years ago

Yup, it's Date

 

  • 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])
    • Yaa_D's avatar
      Yaa_D
      Frequent Visitor
      4 years ago

      Perfect. Thank you!

    • 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