Max date with data

[clarainesgg]

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.

Thank you!

[clarainesgg]

thank you! it worked!

[Greg_Deckler · Accepted solution]

@clarainesgg Sample data would help but should be something like:

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