Forum Discussion

clarainesgg's avatar
clarainesgg
Helper I
1 year ago
Solved

Max date with data

Hi, I need to calculate the max date with data: For example, I have data till  8/11/2024 and 9/1/2024 with no data.   How could i get the max date = 8/11/2024? This needs to be dynamically.   Th...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    clarainesgg Sample data would help but should be something like:

    VAR __MaxDate = MAXX( FILTER( 'Table', [Some Column] <> BLANK() ), [Date] )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

clarainesgg Sample data would help but should be something like:

VAR __MaxDate = MAXX( FILTER( 'Table', [Some Column] <> BLANK() ), [Date] )