Forum Discussion
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.
Thank you!
clarainesgg Sample data would help but should be something like:
VAR __MaxDate = MAXX( FILTER( 'Table', [Some Column] <> BLANK() ), [Date] )
2 Replies
thank you! it worked!
clarainesgg Sample data would help but should be something like:
VAR __MaxDate = MAXX( FILTER( 'Table', [Some Column] <> BLANK() ), [Date] )
