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!