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

Perfect. Thank you!